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.

N2411APuerto Rico Air Management Services Inc · Coral Gables, FLS/N 650-0103 N24136Tj Air Holding Inc Trustee · Wilmington, DEBuilt 1978 · S/N E-1233 N24192Lindeman Rusty L · D Hanis, TXBuilt 1978 · S/N E-1223 N24194Ge King LLC · Lewes, DEBuilt 1978 · S/N E-1222 N241BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5208 N241BFCypress Aircraft Sales LLC · Clermont, FLBuilt 1981 · S/N 5010214 N241DSNcb Air Ventures LLC · Lighthouse Point, FLS/N S550-0042 N241EWFort Carlos LLC · Fort Worth, TXBuilt 1978 · S/N 421C-0496 N241HHOddson Terrance J · Windom, MNBuilt 2001 · S/N E-3427 N241JSE D Santos & Associates LLC Trustee · Wilmington, DES/N 258652 N241MWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 421C0030 N241PHPhi Health LLC · Tempe, AZBuilt 1984 · S/N BB-1182 N241SADiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 556 N241VVWorldwide Aviation LLC · Springfield, MOBuilt 1999 · S/N FL-241 N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922 N24202United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30429 N24211United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28771 N24212United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28772 N24224United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28933 N242BSDm Aviation LLC · Lexington, SCBuilt 1997 · S/N 525-0230 N242DJSouth Eastern Atlantic Aviation LLC · Lewes, DES/N 501-0068 N242EWEco Window Systems LLC · Medley, FLBuilt 2015 · S/N 208B5180 N242LFDavis Aviation Inc · Brandon, MSBuilt 1981 · S/N LA-86 N242LMHeritage Logistics LLC · Holdrege, NEBuilt 2017 · S/N 525-0970 N242PGPage Aviation LLC · Saint Louis, MOBuilt 2018 · S/N 525-0993 N242RCCarrera Aviation LLC · Wilmington, DEBuilt 1972 · S/N TH-248 N242RFOwsley Robert L · Anchorage, AKBuilt 1998 · S/N 525-0294 N242RG242rg LLC · Miami, FLBuilt 2026 · S/N 208B5922 N242SDBinette Alan · Medford, ORBuilt 2020 · S/N 525-1069 N242ZAN667kt LLC · Lewes, DEBuilt 2001 · S/N BB-1761 N243AMAirmed International LLC · Birmingham, ALBuilt 2005 · S/N BB-1896 N243CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N BB-1596 N243EESoutheast Air LLC · Palm Coast, FLBuilt 1981 · S/N 501-0212 N243MHAllen Contracting Inc · Oklahoma City, OKBuilt 1999 · S/N FL243 N243PBFargo Jet Center LLC · Fargo, NDS/N FL-1359 N243PWTexas Parks And Wildlife Department · Austin, TXBuilt 2025 · S/N 208B5855 N243SFMn Design Inc · Paradise Valley, AZBuilt 2002 · S/N 560-0593 N244AFlying Farmer LLC · Wilmington, DEBuilt 1979 · S/N 145 N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066 N244HAHowell Air LLC · Dover, DEBuilt 1996 · S/N LJ-1444 N244JHDecca Aviation Operations Inc · Lincoln, NEBuilt 1976 · S/N E-818 N2458RKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2004 · S/N TH-2089 N245ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35099 N245GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-245 N245JSFe Caravan LLC · Kinston, NCBuilt 2014 · S/N 208B5154 N245LIhlenburg Kirk · Tualatin, ORS/N E-2185 N245RMWrongbros Aviation LLC · West Sacramento, CABuilt 1987 · S/N E-2382 N245SWCrosswinds LLC · Opelousas, LABuilt 1982 · S/N E-2018 N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104 N245TSTexas Recreational Aircraft Club Inc · Houston, TXBuilt 2000 · S/N E-3318

Back to AD 2006-16-18 R1