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.

N880JSDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 421C-0489 N880MBWabash Wings LLC · Fishers, INBuilt 1981 · S/N BB-928 N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769 N880PLExecutive Air Taxi Corp · Bismarck, NDBuilt 1998 · S/N 258380 N880PSVientos Air LLC · Santa Fe, NMBuilt 1996 · S/N 560-0398 N880STTextron Aviation Inc · Wichita, KSS/N FL-1371 N880UPNebraskaland Tire Inc · Wichita, KSBuilt 2018 · S/N FL-1127 N881AFPetrotransit LLC · Cypress, TXBuilt 1996 · S/N 258289 N881DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31992 N881FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0204 N881HASkywings Aviation LLC · Wilmington, DEBuilt 1996 · S/N 078 N881MCFoothills Aviation Partners LLC · Winston Salem, NCS/N BB-1930 N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135 N881RCCooper Companies Inc · Scottsdale, AZBuilt 2007 · S/N 525-0635 N881SASouthern Airways Pacific LLC · Addison, TXBuilt 2015 · S/N 208B-5178 N882CTCharlie Tango Aviation LLC · Rocklin, CABuilt 1990 · S/N E-2566 N882DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31994 N882FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0208 N882JPJpb Air LLC · Rancho Santa Fe, CABuilt 1981 · S/N BB-882 N882MTGta Air Inc · Addison, TXBuilt 1982 · S/N TH1343 N882MZ7-Star Aviation LLC · Addison, TXBuilt 2015 · S/N 525-0882 N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221 N882RBGainesville Aircraft Sales Inc · Gainesville, FLS/N S550-0075 N882SCAti Jet Inc · El Paso, TXBuilt 1984 · S/N 590 N882YDDodson International Parts Inc · Rantoul, KSS/N 140 N883DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31993 N883FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0210 N883GBTica Travel LLC · Tampa, FLBuilt 2007 · S/N FL-520 N883MTFlywheel LLC · Austin, TXBuilt 2015 · S/N 525-0883 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 N883SPSamaritans Purse · Boone, NCBuilt 2001 · S/N 208B0887 N883TXWhitehorse LLC · Puyallup, WABuilt 2008 · S/N 560-0784 N8844Diamond And A Half Cattle Company LLC · Lake Havasu City, AZS/N 525-0254 N884ABJetsteam Aviation Inc · Cheyenne, WYS/N 258097 N884DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31995 N884FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0233 N884LPBecton Aviation LLC · Lubbock, TXS/N 421C0102 N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222 N884RCJannenga Air LLC · Phoenix, AZBuilt 2001 · S/N 560-0552 N88537Gink2 LLC · Elkhorn, NEBuilt 1978 · S/N 421C0514 N88584Dallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0642 N885DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31996 N885JHO & H Air LLC · Paris, TXBuilt 2021 · S/N 525-1098 N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139 N885PESunshine Aircraft LLC · Winter Park, FLBuilt 2001 · S/N 208B0885 N885SPSamaritan'S Purse Inc · Boone, NCBuilt 2026 · S/N 208B5956 N88604Trade Winds Aviation Holdings LLC · Lewes, DEBuilt 1978 · S/N 421C0604 N88606N88606 LLC · Ely, IAS/N 421C0649 N88646Eagle Air LLC · Garden Ridge, TXS/N 421C0630 N886AWAndrew & Williamson Sales Co · San Diego, CABuilt 1986 · S/N FA110

Back to AD 2006-16-18 R1