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.

N85XPB&J Aircraft LLC · Alice, TXS/N BB1202 N860CRGulf Atlantic Airways Inc · Gainesville, FLBuilt 1999 · S/N 560-0500 N860DBWhyriverranch LLC · Mc Leod, MTBuilt 2001 · S/N 525-0434 N860DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31971 N860FWFlorida Fish And Wildlife Conservation Commission · Lakeland, FLBuilt 2023 · S/N 20800699 N860GCHiggins David L · Chevy Chase, MDBuilt 1986 · S/N BB-1245 N860HState Of Ohio Department Of Transportation · Columbus, OHBuilt 2015 · S/N FL-977 N860JAAirborne Aviation LLC · Miami, FLBuilt 1998 · S/N 650-7086 N860NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40583 N860TTWlf Aviation LLC · Stratford, CABuilt 1992 · S/N FL-86 N8611RGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-482 N861CGLolaire LLC · El Dorado Hills, CABuilt 2015 · S/N 525-0861 N861DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31973 N861FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0183 N861HCN861hc LLC · Elk City, OKBuilt 1977 · S/N 421C0438 N861MAAerodynamics Worldwide Inc · Wilmington, DEBuilt 2000 · S/N 208B0825 N861NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31109 N861RXMullen Robert R III Trustee · Woodland Hills, CABuilt 1979 · S/N E-1449 N861SCSpotted Hawk Aviation LLC · Rosenberg, TXBuilt 1997 · S/N E3128 N861ZGGeneral Energy Research Group · Conroe, TXBuilt 1979 · S/N BB-493 N862DRegistered aircraftBuilt 1978 · S/N E-1362 N862DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31972 N862FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0184 N862HTSublett Holdings LLC · Wilmington, DEBuilt 1981 · S/N BB-800 N862NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30905 N8636A36a Ltd · Cincinnati, OHBuilt 1982 · S/N E1977 N863DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31975 N863FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0186 N863JBPj One LLC · Land O Lakes, FLBuilt 1994 · S/N 560-0260 N863MAMartinaire Aviation LLC · Addison, TXBuilt 2004 · S/N 208B1049 N863NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30903 N864AMAirmed International LLC · Birmingham, ALBuilt 2005 · S/N 258733 N864BFPsx LLC · Sheridan, WYBuilt 2002 · S/N 258584 N864CACarver Aero LLC · Muscatine, IAS/N FL-396 N864DCPgv LLC · Camden, DEBuilt 2003 · S/N 258647 N864DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31974 N864NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31111 N864SFAlaska Skypower LLC · Fairbanks, AKBuilt 2000 · S/N 208B0864 N8652RFour Alpha Juliet LLC · Minster, OHBuilt 2000 · S/N E-3354 N86534United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62750 N865DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31976 N865FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0188 N865HPRustair Inc · Anchorage, AKBuilt 1998 · S/N 20800289 N865LRKirmart Inc · Wichita Falls, TXS/N FL-471 N865MASchuman Carriage Co Ltd · Honolulu, HIBuilt 2002 · S/N 208B0996 N865NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29554 N865SHSafe Harbor Aviation LLC · Knoxville, TNBuilt 2012 · S/N FL-820 N866DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31977 N866FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0189 N866KABad Aire LLC · Aledo, TXS/N 421C1255

Back to AD 2006-16-18 R1