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.

N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057 N2DBKa300 LLC · Greenwood Village, COBuilt 1985 · S/N FA-37 N2GGN2gg Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1539 N2JAJadair International Inc · Port Washington, WIBuilt 1976 · S/N 421C0154 N2JCJcmc Inc · Junction City, KSBuilt 1984 · S/N E-2172 N2KBKb Aviation LLC · Mission Viejo, CABuilt 1974 · S/N E-599 N2LYMagnolia Air LLC · Starkville, MSS/N 421C0301 N2MLMclaury Kim · Mission Hill, SDBuilt 1997 · S/N E-3114 N2PAPylon Aviation Services LLC · Chandler, AZBuilt 1982 · S/N 501-0242 N2RCRico Marketing Corp · Flint, MIBuilt 1995 · S/N 5600319 N2TWJuliett Papa LLC · Kalispell, MTBuilt 1994 · S/N 560-0286 N2UPTriton Aviation LLC · Evans, GABuilt 1994 · S/N 650-0227 N2UWUniversity Of Wyoming · Laramie, WYBuilt 2013 · S/N FL-862 N2VACommonwealth Of Virginia · Richmond, VABuilt 2007 · S/N FL-537 N2YCTaglavore Franklin · Irving, TXBuilt 1974 · S/N TH-487 N2ZTwo Zulu LLC · Mclean, VABuilt 1989 · S/N E-2514 N2ZBCitizen Aero Inc Trustee · Sheridan, WYBuilt 2021 · S/N 525-1101 N3001VHillier David C · Oakdale, CABuilt 1947 · S/N D-400 N3002WRio Concho Aviation Inc · Weatherford, TXBuilt 1973 · S/N E-453 N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487 N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365 N300AJAsm Aviation LLC · Bismarck, NDBuilt 1981 · S/N BB-965 N300AWDavis Aviation Inc DBA · Brandon, MSBuilt 2004 · S/N LJ-1716 N300BRMach Tuck Aero Group LLC · Elkhorn, NES/N 421C0453 N300BVCj Bravo Victor LLC · Ridgeland, MSBuilt 2001 · S/N 525-0418 N300CHWorldwide Option LLC · Lewes, DEBuilt 1990 · S/N 560-0080 N300CQHawker 4 LLC · Jensen Beach, FLBuilt 2001 · S/N 258555 N300CWDome Aviation LLC · Loomis, CAS/N FA-115 N300DMLas Montanas Aviation LLC · Oro Valley, AZBuilt 1981 · S/N LA-165 N300FCDresden Aviation LLC · Atlanta, GABuilt 1998 · S/N 525-0248 N300KAHeartland Aviation LLC · Ada, OKBuilt 1990 · S/N FL-28 N300KLPeddinghaus Corp · Bradley, ILBuilt 1985 · S/N FA39 N300MCHighway 16 Ranch LLC · Corpus Christi, TXBuilt 1986 · S/N FA-91 N300PLPolaris Industries Inc · Medina, MNBuilt 2017 · S/N FL-1096 N300PTGjf Enterprises Inc · Port Orange, FLBuilt 1984 · S/N FA-34 N300RTChoux Aviation LLC · Cypress, CABuilt 1983 · S/N E-2074 N300SEJetx Air LLC · Camden, DEBuilt 1985 · S/N FA-68 N300TAMarshmont Aviation LLC · Greenville, SCS/N LA-9 N300TCOrlando Financial Corp · Bear, DEFirst renewal noticeBuilt 1978 · S/N 241 N300TEKingair 61 LLC · Wilmington, DEBuilt 1984 · S/N FA-19 N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266 N300TMTaylor & Martin Enterprises Inc · Fremont, NEBuilt 1991 · S/N FL-50 N300TNWild Blue Aviation LLC · Wilmington, DEBuilt 1988 · S/N FA-168 N300VAAeon62 Holdings LLC · Plano, TXBuilt 1979 · S/N LJ-877 N300WBGarmin International Inc · Olathe, KSBuilt 1994 · S/N 5600271 N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319 N300WMWalker Manufacturing Co · Fort Collins, COBuilt 1988 · S/N FA156 N300WQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1984 · S/N FA-8 N300XL1911 Partners LLC · Rockledge, FLBuilt 1979 · S/N 276 N3013VCusick Christopher J · La Jolla, CABuilt 1947 · S/N D-415

Back to AD 2006-16-18 R1