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.

N866NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40584 N866PMBluview Management LLC · Avon Park, FLS/N 421C0651 N866TCJetz Service Co Inc · Topeka, KSS/N 560-0802 N867BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5243 N867CCLewis Aeronautical LLC · San Antonio, TXBuilt 2014 · S/N 208B5103 N867DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31979 N867FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0191 N867HPCaravan International Leasing Inc · Carson City, NVBuilt 1991 · S/N 208B0252 N867LCCurd Layton · Cypress, TXBuilt 1991 · S/N E-2649 N867LPGlobal Aircraft Leasing Inc · Wilmington, DEBuilt 2023 · S/N 208B5731 N867NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40762 N867SLSafeco Leasing LLC · Port Alsworth, AKS/N BB-867 N867TXAirplane 1 LLC · Richmond, TXBuilt 2002 · S/N 258576 N867UPNorth County Flying LLC · North Palm Beach, FLBuilt 2017 · S/N FL-1098 N867UTTvpx Aircaft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 208B5740 N868CWBig Sky Insulations Inc · Belgrade, MTBuilt 2007 · S/N 560-0757 N868DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31978 N868NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40763 N868PZPvaa LLC · Dover, DEBuilt 2003 · S/N 258633 N868RXAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-84 N868SDBig Wings LLC · Sheridan, WYBuilt 2021 · S/N 20800681 N869CBHpg Holdings LLC · Mesa, AZS/N 525-0453 N869DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31980 N869FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0195 N869KSUniversity Of Central Missouri · Warrensburg, MOBuilt 1993 · S/N TH-1692 N869NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40764 N869XATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0869 N86BBMile High Adventures LLC · Yazoo City, MSBuilt 1993 · S/N FL-107 N86BRBest Aircraft Deals LLC · Salt Lake City, UTS/N 90 N86CDBri Mar Aviation Corp · New Britain, CTBuilt 1997 · S/N E-3145 N86EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 208B5816 N86FDKa Equipment LLC · Charlotte, NCBuilt 2012 · S/N FL-822 N86GALamarque Citation X LLC · Kenner, LABuilt 1993 · S/N FL100 N86MESutherland Jason · Auburn, WABuilt 1999 · S/N E-3285 N86TNBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 241 N870DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31981 N870FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0196 N870NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40765 N870SCElite Air LLC · Jonesboro, ARBuilt 1978 · S/N LJ-773 N870STPennsylvania State Police · Hershey, PAS/N FL-1305 N870TXN870tx LLC · Fort Lauderdale, FLBuilt 2006 · S/N 258763 N870UOhio University · Albany, OHBuilt 2002 · S/N TH-2036 N8713MSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36984 N871ANWnd Aircraft Management LLC · Miami, FLBuilt 1993 · S/N TH-1678 N871CSTurquoise Blue Aviation LLC · Santa Rosa Beach, FLS/N E-2291 N871DNUmb Bank Na Trustee · Salt Lake City, UTS/N 31982 N871FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0198 N871JBAas Baron LLC · Houston, TXS/N TH-2038 N871NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 31127 N871UBFub Air LLC · Lubbock, TXS/N FL-762

Back to AD 2006-16-18 R1