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.

N351BFKbs Aviation LLC · Springboro, OHBuilt 2018 · S/N 525-0995 N351CCSeamour Express LLC · Coral Gables, FLBuilt 2012 · S/N 208B2351 N351DDAir Unlimited Holdings LLC · Wilmington, DEBuilt 2013 · S/N FL-852 N351DYWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N FL-257 N351GFJ W Venture Aviation LLC · Concord, NCBuilt 1995 · S/N FL-129 N351GRDodson International Parts Inc · Rantoul, KSS/N LW-324 N351KBKabco Aviation LLC · Boaz, ALBuilt 2002 · S/N BB-1904 N351LRLr Leasing Inc · Carson City, NVBuilt 1999 · S/N FL-256 N351MPMackie James Robert · Cookeville, TNBuilt 2000 · S/N FL-305 N351SAGuardian Flight LLC · Lewisville, TXBuilt 1992 · S/N BB1423 N35204United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30576 N35236United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28801 N35260United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30855 N35271United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31589 N352CCConcept Aviation Of North Florida Inc · Gainesville, FLBuilt 1991 · S/N 5600151 N352PSWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33256 N352PXPx Partners LLC · Redondo Beach, CABuilt 2010 · S/N FL-723 N3532North Delta Ag Aviation LLC · Sledge, MSBuilt 1977 · S/N BE-31 N3536Vantage Aviation USA LLC · Tampa, FLBuilt 1979 · S/N BE72 N3538New Mountain Aviation LLC · Englewood, COBuilt 1978 · S/N BE-57 N3539Thacker Aircraft Holding LLC · Lubbock, TXBuilt 1982 · S/N BE-124 N353HAMpr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 650-0109 N353JABasler Turbo Conversions LLC · Oshkosh, WIS/N 258729 N353PAAersale Inc · Coral Gables, FLS/N 20622 N35407United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30124 N354AVAev Aviation LLC · Hilton Head Island, SCBuilt 2002 · S/N LJ-1660 N354BCChamberlain Donald H · Ooltewah, TNBuilt 1989 · S/N E-2485 N354LQBrunner Aerospace LLC · Georgetown, TXBuilt 1976 · S/N 055 N354PTAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31275 N355CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 062 N355FAE D Santos & & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258156 N355GBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N FL-1273 N355HGHerricks Bobby · Midland, TXBuilt 2001 · S/N FL-320 N355PCEagles Wings Avaition LLC · Monroeville, ALBuilt 1984 · S/N LJ-1067 N355PUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33348 N355RMLopez Fabio A · Denver, NCBuilt 1982 · S/N 033 N355SAReddy James N Trustee · Port Orange, FLBuilt 2000 · S/N E-3357 N355UALopez Fabio A · Denver, NCBuilt 1984 · S/N 114 N3566WGriffin Aviation LLC · Minneapolis, MNBuilt 1999 · S/N TH-1930 N356BRBdp Airways LLC · Dover, DEBuilt 1982 · S/N 356 N356CETextron Aviation Inc · Wichita, KSBuilt 2025 · S/N FL-1356 N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452 N356ERStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1985 · S/N FA-55 N356HCai Tech LLC · Greenwood, DEBuilt 2004 · S/N E-3566 N356KDAtares Funding LLC · Miami Beach, FLBuilt 1994 · S/N 26356 N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373 N356SAJmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 1994 · S/N 560-0256 N356VCBarrick Gold Of North America Inc · Elko, NVBuilt 2022 · S/N FL-1304 N357BBExecutive Support LLC · Huntsville, ALBuilt 1990 · S/N FL-27 N357BERegistered aircraftBuilt 2004 · S/N 560-0663

Back to AD 2006-16-18 R1