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.

N8584ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64800 N858ALFinnegan Brian · Novato, CABuilt 1990 · S/N E2544 N858AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258731 N858DDDoss Air LLC · Mounds, ILBuilt 1993 · S/N 525-0046 N858DPDgt Aviation LLC · New Bern, NCBuilt 2015 · S/N 525-0896 N858DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31969 N858FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0178 N858FTLogistic Air Inc · Reno, NVBuilt 1970 · S/N 20109 N858GFCal-Ore Life Flight LLC · Brookings, ORS/N BB-1858 N858LPFulps Aviation LLC · Winston Salem, NCBuilt 1978 · S/N TH-902 N858MAMess Aero Inc · Grand Forks, NDBuilt 1997 · S/N 20800262 N858MEFlying Turtles Two LLC · Dallas, TXBuilt 1994 · S/N 560-0253 N858NCIal Corp · Lewes, DEBuilt 1977 · S/N TH-813 N858NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30904 N858PBEast Ky Mobile Movers Inc · Pikeville, KYS/N TH-1541 N858PRMelbourne Air Partners LLC · Indialantic, FLBuilt 1981 · S/N TH-1221 N858SPBrown Lawson M II · San Diego, CABuilt 1974 · S/N 11 N858WGreat Pond LLC · Bedford, MAS/N TH-2060 N858WWMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1993 · S/N 064 N859AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 32796 N859BEBlue Eagle Airways Inc · San Juan, PRBuilt 1983 · S/N 120147 N859CBoe Ndt LLC · Haysville, KSBuilt 2001 · S/N E-3395 N859DMDavis Mark E · Pearland, TXS/N 421C0859 N859DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 31970 N859FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0181 N859MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2424 N859NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29555 N85BBAvanti Aviation LLC · Bellevue, NEBuilt 1973 · S/N E-508 N85CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0125 N85DRWashington Air LLC · Richland, WABuilt 1978 · S/N LJ-767 N85EBGt Commercial Interests LLC · Austin, TXBuilt 1998 · S/N 560-0492 N85ECHammett Wilbur Jeffrey · Saint Augustine, FLBuilt 1985 · S/N E-2278 N85FCFlow Companies LLC · Winston Salem, NCBuilt 2018 · S/N FL-1170 N85FS7353r Co Partnership · Pottstown, PABuilt 1974 · S/N TH-486 N85GWMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1976 · S/N LJ-712 N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498 N85KSCnet Aviation LLC · Lindale, TXBuilt 1978 · S/N 421C0525 N85LGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N LJ-1487 N85LXWestern Stage Express LLC · Dubuque, IABuilt 2021 · S/N 525-1085 N85MSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1985 · S/N 650-0075 N85PCSolomon Mark Trustee · Wilmington, DEBuilt 1990 · S/N LJ-1262 N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285 N85SCStruthoff Co Inc · San Antonio, TXBuilt 2015 · S/N 525-0898 N85TBCentral Virginia Aviation Inc · Petersburg, VABuilt 1979 · S/N LJ-833 N85TNLls Aviation LLC · Nederland, TXBuilt 1993 · S/N 237 N85UTFly Mwm LLC · Kemah, TXBuilt 1980 · S/N BB-678 N85VRBd Charters LLC · Henderson, TXBuilt 2001 · S/N 525-0425 N85WHM Hixson Aviation LLC · Lake Dallas, TXBuilt 2021 · S/N 525-1088 N85WLWillis Lease Finance Corp · Larkspur, CABuilt 1995 · S/N 20800245 N85WTExcalibur International Aviation Inc · Spring, TXBuilt 1988 · S/N 650-0162

Back to AD 2006-16-18 R1