Registered aircraft · 11,798

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N88EZMusack Randy A · Butternut, WIBuilt 2000 · S/N E-3364 N88FARegistration Pending · Helena, MTRegistration pendingBuilt 1979 · S/N BE-74 N88GLWichita State University · Wichita, KSBuilt 1981 · S/N LJ-945 N88HMFinch Air LLC · Midland, TXBuilt 1970 · S/N LJ-502 N88HRHansen Ranches LLC · Corcoran, CABuilt 1998 · S/N FL-225 N88JHTeton Aviation Limited Liability Company · Wilson, WYBuilt 1989 · S/N BB-1331 N88LSPrince George Aviation LLC · Memphis, TNBuilt 2001 · S/N 525-0475 N88MTFlight Company LLC · Rome, GABuilt 1981 · S/N BB-830 N88MYBullrock Corp · South Burlington, VTBuilt 1983 · S/N BB-1142 N88NWWnd Aircraft Management LLC · Miami, FLBuilt 1988 · S/N S550-0151 N88PEFirst Winds LLC · Norfolk, NES/N 421C0851 N88PRValley River Leasing Inc · Murphy, NCBuilt 1995 · S/N E-2982 N88TPCruson James W · Spring Creek, NVBuilt 1968 · S/N E-86 N88TSWrb Aircraft LLC · New York, NYBuilt 1988 · S/N E-2409 N88TWWheel-Air LLC · Mentor, OHBuilt 1998 · S/N 20800292 N88UACentral Virginia Aviation Inc · Petersburg, VABuilt 1988 · S/N RJ-49 N88VNAt Aero LLC · Wilmington, DEBuilt 1986 · S/N BB-1250 N88WAWiseman Aviation Inc · Flagstaff, AZBuilt 1983 · S/N LJ-1057 N88XJN88xj LLC · Park Ridge, ILBuilt 1998 · S/N LJ-1525 N88XSDe510 LLC · Atlanta, GABuilt 2018 · S/N FL-1169 N890ACDodson Intenrational Parts Inc · Rantoul, KSBuilt 1983 · S/N 92 N890BA818 Operations Inc · Wilmington, DES/N 301 N890DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62775 N890FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0219 N890MTRauch Richard B · Wilsonville, ORBuilt 2015 · S/N 525-0890 N890NCDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N LJ-893 N890NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31143 N890VPDodson International Parts Inc · Rantoul, KSS/N BB-1116 N8911XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1998 · S/N E-3166 N891AAAugusta Aviation Inc · Augusta, GAFirst renewal noticeBuilt 1989 · S/N LJ-1221 N891DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32001 N891FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0221 N891FVSuper King LLC · Wilmington, DEBuilt 1997 · S/N 560-0427 N891KSParr Aviation LLC · Demopolis, ALBuilt 1993 · S/N 560-0210 N891LMn Aircraft LLC · Carolina, PRBuilt 2002 · S/N 208B0938 N891NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33315 N891SHHulfe Air LLC · Caguas, PRBuilt 1991 · S/N 650-0210 N891TDMassachusetts State Police · Plymouth, MABuilt 2019 · S/N 208B5553 N892DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32000 N892FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0222 N892HMBrig Air LLC · Birmingham, MIBuilt 1983 · S/N 501-0320 N892JHMaitland Property Management LLC · Plano, TXBuilt 2000 · S/N E-3323 N892NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31145 N892QMMedina Iran · North Bay Village, FLS/N 078 N892TXByte Me Transportation Inc · Fort Pierce, FLBuilt 2002 · S/N 258592 N893DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32002 N893NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33316 N893TCCaravan Air Inc · Livingston, MTBuilt 2014 · S/N 20800565 N894DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62776 N894FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0224

Back to AD 2006-16-18 R1