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.

N886DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31998 N886FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0190 N886NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33223 N886SPSamaritan'S Purse · Boone, NCBuilt 2002 · S/N 208B0934 N887ACBrg Enterprises LLC · Johns Island, SCS/N TH-603 N887BDBolin Industries · Hamburg, ARBuilt 1963 · S/N 1249-74 N887BMNewman Matthew · Warwick, NYBuilt 1997 · S/N E-3122 N887CAHerron Joe D · Burnet, TXBuilt 1976 · S/N E-864 N887DCBlbird LLC · Modesto, CABuilt 2023 · S/N FL-1312 N887DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 31997 N887FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0216 N887JKHenry Joseph · Paris, TXS/N E-3586 N887NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31141 N887SBGosmartair LLC · Harrisburg, PABuilt 2015 · S/N 525-0887 N8881JGdc Aviation LLC · Jacksonville, FLBuilt 1992 · S/N 258219 N8885ZGreenwood Express LLC · West Des Moines, IABuilt 2014 · S/N FL-940 N8887BSt Croix Acceptance Corp · Devils Lake, NDBuilt 1987 · S/N LJ-1148 N888AOlivia Aviation LLC · Plymouth, MNBuilt 2000 · S/N E-3304 N888AERegistered aircraftBuilt 1978 · S/N E-1323 N888ASStanislaus Food Products Co · Modesto, CABuilt 1987 · S/N FA-136 N888DUDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31999 N888ETBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N BB-258 N888FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0217 N888FMLasai Aviation LLC · Reston, VABuilt 2004 · S/N FL-418 N888GDCluheir LLC · Van, TXBuilt 2002 · S/N 560-0634 N888HJAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB444 N888HTFortenberry Aviation LLC · Crossville, ALBuilt 2000 · S/N FL-273 N888JRJones & Weaver Pc · Wheatland, WYBuilt 1978 · S/N E-1241 N888LSLadd Sanger · Saratoga, WYBuilt 2020 · S/N 525-1048 N888MPProbasco Mitch · Floydada, TXBuilt 1990 · S/N BB-1358 N888MZM-Z Aviation LLC · Birmingham, ALBuilt 1988 · S/N E-2417 N888PNPpn Air LLC · Laguna Beach, CAS/N 501-0080 N888RAHope Air LLC · Lewes, DES/N 525-0135 N888WEPrime Aircraft & Aviation LLC · Edmond, OKS/N 394 N888ZTRev Aircraft LLC · Wilmington, DEBuilt 1978 · S/N LW315 N888ZXEm Air LLC · Richland, WABuilt 1983 · S/N BB-1140 N889AVAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2002 · S/N 258581 N889AXPacific Gas And Electric Co · Concord, CABuilt 2014 · S/N 208B5171 N889DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 62774 N889FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0218 N889FTMolly Willis Ventures LLC · Albany, GABuilt 1997 · S/N TH-1828 N889NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33314 N889SEasy Air LLC · Wilmington, DEBuilt 1984 · S/N E-2138 N889SHRedfish Holdings Inc · King Salmon, AKS/N 501-0681 N889TAPrivate Flight II LLC · Oklahoma City, OKBuilt 2014 · S/N 525-0823 N88ADN88ad Leasing LLC · Jackson, TNBuilt 2000 · S/N 525-0404 N88BAir Taco LLC · Virginia Beach, VABuilt 1982 · S/N E-2036 N88BPPlane LLC · Worcester, MABuilt 1993 · S/N E-2780 N88CJLyman Michael R · Lake Oswego, ORBuilt 1977 · S/N E-1042 N88ESChapman Kevin J · Williston, NDBuilt 1975 · S/N E-758

Back to AD 2006-16-18 R1