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.

N904ATBeitler Jonathan J · Camden, MEBuilt 1991 · S/N E2629 N904BCFox 3 Partners LLC · Virginia Beach, VABuilt 1981 · S/N 421C1027 N904DGCentral Virginia Aviation Inc · Petersburg, VAFirst renewal noticeBuilt 1983 · S/N BB-1176 N904DKAerolease LLC · Fargo, NDBuilt 1984 · S/N LJ-1089 N904DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32008 N904FEFederal Express Corporation · Memphis, TNS/N 208B0004 N904GWCobb Industrial Inc · Holly Springs, GABuilt 2008 · S/N 525-0681 N904HBohanon Air LLC · Jonesboro, ARBuilt 1979 · S/N LW-239 N904HBState Of Louisiana · Baton Rouge, LABuilt 1990 · S/N LJ-1256 N904JJetran LLC · Horseshoe Bay, TXBuilt 1991 · S/N 560-0144 N904LRChrysler Aviation Inc · Van Nuys, CABuilt 1992 · S/N 560-0163 N904MCReliant Air Charter Inc · Danbury, CTBuilt 1991 · S/N FL-44 N904NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33317 N904PSpeed Aviation Inc · Bay Minette, ALBuilt 1988 · S/N LJ1181 N904PB34 Bravo LLC · Pine Bluff, ARBuilt 1981 · S/N LJ-962 N904RBColumbia Flight Group LLC · Columbia, MOBuilt 1985 · S/N LJ-1088 N904SHSanford Medical Center · Sioux Falls, SDBuilt 1998 · S/N BB-1614 N904THFlying Petroleum LLC · El Dorado, ARS/N LJ-1680 N9055FSivu Transportation LLC · Anchorage, AKBuilt 2022 · S/N 208B5664 N9056SKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N E-1301 N9058QHeffley Lynn · Pottsboro, TXBuilt 1970 · S/N TH-95 N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507 N905ATWagner Kendall · Yorba Linda, CABuilt 1991 · S/N E2632 N905CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 005 N905DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32009 N905FEFederal Express Corporation · Memphis, TNS/N 208B0005 N905GSGlh Capital LLC · Pittsfield, MABuilt 2023 · S/N 525-1137 N905GWN905gw LLC · Lake Park, GABuilt 2008 · S/N 525-0682 N905LCLoraine LLC · Wilmington, DEBuilt 1995 · S/N 560-0334 N905MSLiz Air Ca LLC · Santee, CABuilt 2023 · S/N FL-1321 N905NANational Aeronautics And Space Administration · Houston, TXBuilt 1970 · S/N 20107 N905NDDodson International Parts Inc · Rantoul, KSS/N BB-468 N905NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31156 N905NYAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-6 N905RTOregon Department Of Forestry · Salem, ORBuilt 1970 · S/N 297 N905SHSanford Medical Center · Sioux Falls, SDS/N BB-1582 N90654Registered aircraftBuilt 2009 · S/N FL-654 N9066SPower Flow Systems Inc · Daytona Beach, FLBuilt 1978 · S/N E-1305 N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508 N906ASSpencer Air LLC · Tucson, AZBuilt 2002 · S/N 258569 N906DCHarrington Douglas R Jr · League City, TXFirst renewal noticeBuilt 1982 · S/N BB-1094 N906DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64879 N906FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0006 N906NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31155 N906RRHill Country Restaurants Inc · Nacogdoches, TXBuilt 2016 · S/N 525-0906 N906TWWonderview Capital LLC · Oklahoma City, OKBuilt 2018 · S/N FL-1138 N906WGClbs Equipment LLC · Prosper, TXBuilt 2022 · S/N 525-1122 N9072SSaddleback Enterprises LLC · Newport Beach, CABuilt 1978 · S/N E-1307 N9072UN9072u LLC · Ocala, FLBuilt 1986 · S/N S550-0106 N9074QDulin Michael N · Edmond, OKBuilt 1970 · S/N E-235

Back to AD 2006-16-18 R1