Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N2139XAerometrix LLC · Lino Lakes, MNBuilt 1965 · S/N 337-0039 N213AAAir Mac Ventures LLC · Houston, TXBuilt 2007 · S/N 172S10511 N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380 N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580 N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046 N213GCEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 21062368 N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130 N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312 N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282 N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572 N213SMArrowhawk Imaging LLC · Morgantown, WVBuilt 2003 · S/N 20608206 N21401Sterling Steven G · Richland, WABuilt 1972 · S/N 18261612 N21402Hester James Timothy · Fayetteville, GABuilt 1972 · S/N 18261613 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N21404Usglap · Fort Morgan, COBuilt 1972 · S/N 18261615 N21405Brushwood John W · Coshocton, OHBuilt 1972 · S/N 18261616 N2140GBoger Malcolm L · Dickens, TXBuilt 1958 · S/N 51440 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540 N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273 N21414Flyboys Flying Club LLC · Pawleys Island, SCBuilt 1972 · S/N 18261624 N21416Campbell David Lloyd · Fredericksburg, TXBuilt 1972 · S/N 18261626 N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297 N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341 N2141GFreiheit Larry · Clinton, MOBuilt 1958 · S/N 51441 N2141QNeuman Allen D · Sanger, TXS/N 177RG0541 N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562 N21421Paul Janet K · Beaver Island, MIBuilt 1972 · S/N 18261630 N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542 N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104 N21445Woody Dwain F Trustee · Lubbock, TXBuilt 1972 · S/N 18261632 N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946 N2144RButterfield Stephen · Nampa, IDS/N 18255344 N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276 N2144ZBeerle Brion J · Anchorage, AKBuilt 1963 · S/N 18051244 N21450Brant Gary E · Salisbury, PABuilt 1972 · S/N 18261637 N21453Super D Electric Inc · Coeur D Alene, IDBuilt 1972 · S/N 18261640 N21454Textron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18281228 N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950 N21457Registration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 18261642 N2145GGraham William F III · North Wilkesboro, NCBuilt 1958 · S/N 51445 N2145JSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9418 N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545 N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106 N2145TCff Air Inc · Wilmington, DES/N 17281174 N2145YRegistration Pending · Spokane, WARegistration pendingS/N 17249645 N21461Acme Aviation Inc · Lake Charles, LABuilt 1972 · S/N 18261645 N21462Fly Man LLC · Waxhaw, NCBuilt 1972 · S/N 18261646 N21465Clary Kenneth W Sr · Huntsville, TXS/N 18261648 N2146AZhukov Igor · Live Oak, FLBuilt 2003 · S/N 18281265

Back to AD 79-10-14 R1