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.

N27TBBos Dairies LLC · Lake Havasu City, AZS/N S550-0082 N27TZSparrow Aircorp Inc · Dover, DEBuilt 1977 · S/N 213 N2803MBonanza N2803m LLC · Conway, ARBuilt 2002 · S/N E-3463 N2804VPlumcrazy Aviation LLC · Ellenboro, NCBuilt 1947 · S/N D-201 N280AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 60582 N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332 N280HPTextron Aviation Inc · Wichita, KSS/N 20800734 N280RATechnology Service Corp · Arlington, VABuilt 1975 · S/N BB-53 N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740 N280WDWak Aviations LLC · Green Bay, WIBuilt 2017 · S/N FL-1104 N2813VAdair Edward A · Hemet, CABuilt 1947 · S/N D-214 N2819VElgin Sky Snoopers Inc. · Crystal Lake, ILBuilt 1947 · S/N D-221 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 62679 N281ARKing Scott · Knoxville, TNBuilt 1978 · S/N TH-991 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N281PMPlanemasters Ltd · West Chicago, ILS/N 208B-0902 N2820VLundstedt Garry R · Fort Collins, COBuilt 1947 · S/N D-222 N2821VSchmitt Rudy · Brookshire, TXBuilt 1947 · S/N D-225 N2824VBigfoot Aviation LLC · Saint Michael, MNBuilt 1947 · S/N D-228 N282AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 62473 N282AMRfp Enterprises Inc · Bridge City, TXBuilt 1997 · S/N BB-1571 N282DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N LW-209 N282EAGalaxy Lift II LLC · Blountville, TNS/N TH-2082 N282HVN282hv LLC · Amarillo, TXBuilt 1994 · S/N 560-0282 N282LSJh Strain & Sons Inc · Tye, TXBuilt 1975 · S/N BB82 N282MWMetropolitan Water District Of Southern California · Los Angeles, CABuilt 2020 · S/N 208B5598 N282PCW O Powers Management Inc · Florence, SCBuilt 1981 · S/N 31T-8166006 N282PMPlanemasters Ltd · West Chicago, ILBuilt 2002 · S/N 208B0981 N282TRed Star Aero Holdings LLC · Lewes, DEBuilt 1974 · S/N 42 N2830AMarathon Heater Inc · Del Rio, TXBuilt 1970 · S/N E-201 N2834VKieper Mark A · Hampton, MNBuilt 1947 · S/N D-239 N283AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 36358 N283JDDurham Aircraft LLC · Port Aransas, TXBuilt 1991 · S/N FL-69 N283MAAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1975 · S/N TH-669 N283PMPlanemasters Ltd · West Chicago, ILBuilt 1999 · S/N 208B0774 N283TMSpady Jeffrey · Springfield, ORBuilt 1998 · S/N E-3185 N2844DMichigan Aeronautics Commission · Lansing, MIBuilt 1994 · S/N TH-1726 N28457United Airlines Inc · Chicago, ILBuilt 2012 · S/N 41744 N2846VRegistration Pending · Shawnee, OKRegistration pendingS/N D-251 N28478United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31649 N284AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 64152 N284DReeves Stephen Trustee · Brawley, CABuilt 1978 · S/N E-1303 N284DMDreamworks Aviation LLC · Palm Beach Gardens, FLBuilt 1984 · S/N 421C1406 N284EXCaravan Ex LLC · Kalispell, MTBuilt 2016 · S/N 208B5284 N284HSAxis Aviation LLC · Boerne, TXBuilt 1995 · S/N 560-0305 N284KMidsouth Air LLC · Lewes, DEBuilt 1979 · S/N BB-608 N284MRDale Aviation Inc · Rapid City, SDBuilt 2005 · S/N LJ-1729 N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734 N2852WButcher Charles · Germantown, TNBuilt 1973 · S/N TH-349

Back to AD 2006-16-18 R1