OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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
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.

N980VCN980vc Corp · Wilmington, DEBuilt 1977 · S/N BE19N980VPAircraft Partner Holdings Inc Trustee · Fallbrook, CAS/N 525-0098N981AGInternational Aviation Sales Ltd · Cleveland, OHBuilt 1998 · S/N 560-0466N981ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29569N981BBGuardian Flight LLC · Lewisville, TXS/N BB-1960N981CLHawker N981ce & N987ce LLC · Wilmington, DEBuilt 2002 · S/N 258563N981DBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1996 · S/N 258302N981FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0110N981LLState Of Il Dot · Springfield, ILBuilt 1999 · S/N FL-265N981NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31230N9820FPa1 208b-0410 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0410N9829BSkydive Buckeye · Buckeye, AZBuilt 1988 · S/N 208B0116N982ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31067N982FLTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N FL-982N982GAMadaket Atlas LLC · Nantucket, MABuilt 1976 · S/N BB-149N982NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31231N982RAInbound LLC · Overland Park, KSBuilt 1982 · S/N BB1082N982SBCal-Ore Life Flight LLC · Brookings, ORBuilt 1998 · S/N LJ-1518N982TMAt Aero LLC · Wilmington, DEBuilt 1977 · S/N BB-226N982TPYarab Holdings I LLC · Clearwater, FLBuilt 2019 · S/N 20800651N9836PTurbo Property LLC · Clovis, CABuilt 1998 · S/N E-3169N9836SForest Kevin · Langdon, NDBuilt 1998 · S/N E-3210N983ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29570N983ARS2c LLC · Wilmington, DEBuilt 1999 · S/N FL-242N983FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0113N983NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33337N98437Infranco Anthony · Amityville, NYBuilt 1975 · S/N 421C0040N984ACSpirit Air Inc · Salmon, IDBuilt 2009 · S/N 208B2081N984BCRegistered aircraftBuilt 1978 · S/N TH-984N984FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0115N984JDWuca LLC · Minnetrista, MNBuilt 2007 · S/N 20800413N984LSBest Citation 2 LLC · N Canton, OHBuilt 2018 · S/N 525-0984N984MAExtraordinary Air LLC · Greenville, SCBuilt 1980 · S/N LJ883N984NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31234N984RPShippy Aviation LLC · Henderson, COBuilt 2003 · S/N FL-368N985ABSafford Aviation Service Inc · Coolidge, AZBuilt 1999 · S/N LJ-1561N985APAlpha Papa LLC · Houma, LABuilt 2013 · S/N FL-886N985CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 258490N985FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0117N985FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2369N985NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31233N986DSSchool Board Of Marion County Florida · Ocala, FLBuilt 1983 · S/N 501-0321N986FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0194N986FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2377N986HHUwg100 LLC · Opa Locka, FLBuilt 1990 · S/N 041N986NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31236N986PREdwards Air LLC · Paducah, KYBuilt 2015 · S/N 525-0886N986WUS Government · Washington, DCS/N 208B1086N986YDv Aviation Inc · Brainerd, MNBuilt 1985 · S/N E-2233N9876TJr Aviation LLC · Benton, KSBuilt 1975 · S/N E-795
Back to AD 2006-16-18 R1