OpenAirDocs.org
AD 2006-16-18 R1

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

N410MCBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N LJ-761N410RTStewart Aviation Services LLC · Birmingham, ALBuilt 2007 · S/N BB-1978N410RWButler National Inc · New Century, KSBuilt 1982 · S/N E-2031N4115SDanielson Adam M · Chassell, MIS/N TH-644N4118KSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1283N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520N411CKFairchild Bill R · Dalhart, TXS/N 421C0229N411EHeli Thrills LLC · Wills Point, TXBuilt 1968 · S/N E-24N411GCWb Air2021 LLC · Cochran, GABuilt 1997 · S/N FL163N411GJGuardian Jet LLC · Guilford, CTBuilt 1990 · S/N E-2586N411GVPa1 208b-0672 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0672N411KCPonderosa Aviation LLC · Safford, AZBuilt 1981 · S/N BB-901N411MHObair 26 LLC · Memphis, TNBuilt 1979 · S/N BB-566N411MLRosner Louis M · Port Orange, FLBuilt 1972 · S/N E-308N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411SCRegistered aircraftBuilt 2004 · S/N 258653N411VRAirtrust LLC -10-Series 10 Trustee · Sheridan, WYBuilt 2001 · S/N 525-0411N411WAGuardian Flight LLC · Lewisville, TXBuilt 1988 · S/N BB-1294N411WCBpi LLC · Maple Lake, MNBuilt 2007 · S/N FL-571N4121XSignature Remodeling LLC · Boonville, MOBuilt 1975 · S/N E-651N4124SAvondale Aviation LLC · Park Ridge, ILBuilt 1975 · S/N E-653N4124WGeaux Automotive Advertising LLC · La Place, LABuilt 2000 · S/N TH-1943N412CBGwvk LLC · Kansas City, KSS/N FL-440N412DPickens Ray T · Pleasanton, TXBuilt 1974 · S/N TH-464N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061N412JADodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 258516N412TFBig Grand Aviation LLC · Jupiter, FLBuilt 2018 · S/N 20800611N4130SYakish S Dale · Wexford, PABuilt 1975 · S/N TH-612N413ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 35205N413BKc Beech Front Ltd · Kansas City, KSBuilt 1948 · S/N D-1419N413CTEagle LLC · Missoula, MTBuilt 1985 · S/N S550-0017N413GATurbo Prop Investors LLC · Parker, COS/N LJ1666N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413N413MBrookway Investments LLC · Brookhaven, MSBuilt 1977 · S/N E1151N413MHFastair Inc · Columbia Station, OHBuilt 1987 · S/N 650-0148N413RCGreen Steam Aviation LLC · Springfield, ILBuilt 1992 · S/N 650-7017N413VLFalcon Vl LLC · Wilmington, DEBuilt 2006 · S/N 345N413VVGardner John · New Hudson, MIBuilt 1979 · S/N 421C-0641N413WGHavana Farms Equipment · Gilliam, LABuilt 1976 · S/N E-804N413WJN492a LLC · Goodyear, AZS/N 463N4144SJlh Ent LLC · Wilmington, DEBuilt 1975 · S/N E-655N414CYLifesouth Community Blood Centers Inc · Gainesville, FLBuilt 2018 · S/N 208B5452N414PEAerotrust Services Corp Trustee · Wilmington, DES/N 258090N414RTPremier Aviation LLC · Philadelphia, MSBuilt 1981 · S/N LA-110N414SWRmi Air LLC · Ocilla, GABuilt 1977 · S/N TH-797N4155FOmg Air LLC · Redwood City, CABuilt 1992 · S/N E-2721N4156SMatt Cartwright · Austin, TXBuilt 1975 · S/N E-660N415GB415gb LLC · Encinitas, CABuilt 2000 · S/N E-3363N415JLOlson Douglas W · Yarmouth Port, MABuilt 1981 · S/N E-1801N415LWWest Thomas Lee · Payson, AZBuilt 1984 · S/N TH-1417
Back to AD 2006-16-18 R1