Registered aircraft · 11,797

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.

N98WENorthern Aviation LLC · Roberts, MTBuilt 1997 · S/N E-3146 N98WPWalsh Aviation LLC · Midland, TXBuilt 1997 · S/N LJ1493 N98XSMerlin One Aircraft LLC · San Antonio, TXBuilt 1995 · S/N 650-7058 N99000Madras Trading Corp · New York, NYNon-citizen corporation, flight hours not reportedS/N 5600299 N990ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29563 N990BMMorse Donald W · Priest Lake, IDBuilt 1980 · S/N LA-70 N990CBB & G Aircraft LLC · Flanders, NJBuilt 1994 · S/N LJ-1362 N990EVEncore Jet Management LLC · San Antonio, TXBuilt 1999 · S/N 258412 N990FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2276 N990GRTas Pipeline Logistics LLC · Houston, TXBuilt 2009 · S/N FL-622 N990JHBluebird Opportunities LLC · Helena, MTBuilt 2007 · S/N 560-0754 N990LAMustang West Aero LLC · Midland, TXBuilt 2000 · S/N LJ-1613 N990LSK&A Advisors LLC · Wilmington, DEBuilt 1975 · S/N LJ-677 N990NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31241 N990RBTvpx Aircraft Solutions Inc - Trustee · North Salt Lake, UTS/N 650-0079 N990SHAviation Co Inc · Cheyenne, WYBuilt 1976 · S/N BC-12 N990WTAmerican King Air LLC · Escalon, CABuilt 1987 · S/N FA-121 N9915ZWysteria LLC · Rock Island, ILBuilt 2002 · S/N 525-0504 N991ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 30920 N991FRAudaciter LLC · Fort Lauderdale, FLBuilt 2004 · S/N 258660 N991FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2279 N991GLCrestron Electronics Inc · Rockleigh, NJS/N E-2953 N991LLState Of Illinois · Springfield, ILBuilt 1996 · S/N FL-142 N991NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31242 N991SRIsr Aviation LLC · Wilmington, DEBuilt 1999 · S/N 525-0295 N991SUAviation Enterprises LLC · Longwood, FLBuilt 1977 · S/N BB-253 N991WWAssured Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1158 N992ANWilmington Trust Co - Trustee (2008 Msn 31071) · Wilmington, DEBuilt 2009 · S/N 31071 N992FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0128 N992FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2288 N992MAJet Rider LLC · Wilmington, DES/N FL271 N992NANational Aeronautics And Space Administration · Houston, TXBuilt 1980 · S/N 309 N992NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31244 N992TLMulzer Timothy J · Santa Claus, INBuilt 1992 · S/N E-2715 N993CBTri-Counties Bank · Chico, CABuilt 1999 · S/N LJ-1550 N993FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0130 N993FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2289 N993GLCody Aviation Partners LLC · Salt Lake City, UTBuilt 2003 · S/N 525-0509 N993NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33340 N993SGHazel Aviation LLC · Mcdonough, GABuilt 1998 · S/N 258377 N9942SHarvey Jerry L · Pompano Beach, FLS/N 96022 N994BABering Air Inc · Nome, AKBuilt 2021 · S/N 208B5631 N994CFKk Air Leasing LLC · Tamarac, FLBuilt 1999 · S/N FL-248 N994FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0132 N994FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2315 N994MLGc Air LLC · Knoxville, TNBuilt 1981 · S/N BB-994 N994MTOld School Consulting And Management LLC · Henderson, TXBuilt 1988 · S/N S550-0158 N994MZMahz Air LLC · Laredo, TXBuilt 1985 · S/N 421C1803 N994NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33248 N9955MBell Jason W · Mount Pleasant, TXBuilt 1989 · S/N TH-1575

Back to AD 2006-16-18 R1