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.

N82LBLakeland Aircraft Maintenance LLC · Lakeland, FLBuilt 1978 · S/N TH-910 N82LHAirborne Support Group LLC · Marion, MTBuilt 1969 · S/N 208 N82RFRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 20800124 N82RSFly Mda Aviation LLC · Opa Locka, FLBuilt 1997 · S/N 258336 N82TPLjr Air LLC · Vineland, NJBuilt 2017 · S/N FL-1086 N82UCMajesty Air Inc · Wilmington, DEBuilt 1972 · S/N TH-276 N82VMAfo Holdings LLC · Sheridan, WYBuilt 1985 · S/N S550-0051 N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034 N82XPJones Harry R Jr · Houston, TXBuilt 1982 · S/N LJ-1012 N83Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-18 N83000Gehrer Aviation LLC · Wichita, KSBuilt 1993 · S/N E-2829 N8306Omega Air Inc · Selma, TXS/N 48306 N8308Omega Air Inc · Selma, TXS/N 48308 N830CCCreson John L Jr · Augusta, GABuilt 1970 · S/N TH-31 N830DFNella Next LLC · Auburn, CABuilt 2022 · S/N 525-1125 N830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CABuilt 1991 · S/N 222 N830DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31940 N830ECAvfrac Nb LLC · Seguin, TXBuilt 1987 · S/N S550-0139 N830JBCalcutta Air LLC · Dover, DEBuilt 1992 · S/N 560-0164 N830MG303sd LLC · San Jose, CABuilt 1991 · S/N 650-0209 N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091 N830TDWhite And Blue LLC · Auburn, CABuilt 1987 · S/N E-2397 N830UPIsr Platforms LLC · Tysons, VABuilt 2014 · S/N FL-941 N8310Omega Air Inc · Selma, TXS/N 48310 N831ATAero 3 LLC · New London, NCBuilt 2021 · S/N FL-1270 N831DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31942 N831FEFederal Express Corporation · Memphis, TNS/N 208B0225 N831LSMojave Aviation LLC · Fort Wayne, INS/N FL-390 N831LXM&N Equipment LLC · Englewood, COBuilt 2000 · S/N 258510 N831MWKdm Ltd · Santa Teresa, NMS/N BB-1850 N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211 N831RMBarber John R Trustee · Port Orange, FLS/N E-1685 N831UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-943 N831VPAlana 650 Aircraft LLC · Waterford, MIBuilt 1990 · S/N 650-0194 N831WPVagus Group Inc · Wilmington, DEBuilt 1979 · S/N BB-569 N832DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31943 N832HFalkenthal Robert J · Beaumont, CABuilt 1977 · S/N E-1047 N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521 N832RSHaps Shack Express LLC · Asheville, NCBuilt 1978 · S/N E-1345 N832UPAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2014 · S/N FL-945 N832WDDodson International Parts Inc · Rantoul, KSS/N 190 N833CCAlc Air LLC · Irvine, CABuilt 2022 · S/N FL-1306 N833DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31944 N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093 N833PBSoutheast Flyers LLC · Jackson, MOBuilt 1986 · S/N E2338 N833UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-947 N8341CAir Commander LLC · Woodbury, MNS/N 525-0150 N834DCYoung John A Trustee · Driggs, IDBuilt 1985 · S/N S5500035 N834DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31946 N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576

Back to AD 2006-16-18 R1