Skip to content

Registered aircraft · 40,394

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N8332RDelehanty Sean M · Mattituck, NYBuilt 1966 · S/N 28-22204 N8332WSurls Aviation Inc · Peculiar, MOBuilt 1965 · S/N 28-2512 N83330Olson Jerry W · Seward, AKBuilt 1976 · S/N 18-7609080 N83332Adamson Todd M · Cody, NEBuilt 1976 · S/N 18-7709050 N83335Peters Nancy A Trustee · Corning, MOBuilt 1976 · S/N 18-7609085 N83337Hubbell Wallis E · Federal Way, WABuilt 1976 · S/N 18-7609084 N8333LLedford Daniel R · Granbury, TXBuilt 1968 · S/N 17256533 N8333TRas Aviation LLC · Elyria, OHBuilt 1981 · S/N 28-8116146 N8333WKeeble Robert H Sr · Loudon, TNBuilt 1965 · S/N 28-2514 N8333XBrownlee Mark B · Helena, MTBuilt 1961 · S/N 17248833 N83345Whytes Inc · Coconut Creek, FLBuilt 1981 · S/N 28-8116153 N83346Riedel Alexander W · Seguin, TXBuilt 1976 · S/N 18-7609086 N83347Farrier Ken J · Torrington, WYBuilt 1976 · S/N 18-7609087 N83349Betz Timothy W J · Anchorage, AKS/N 18-7609089 N8334LAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1968 · S/N 17256534 N8334PCanta Alain Ongkeko · Northridge, CABuilt 1981 · S/N 28-8116149 N8334WGhenciu Petre I · Homer Glen, ILBuilt 1981 · S/N 28-8116150 N8334YOncore Aviation LLC · Rochester, NYBuilt 1981 · S/N 28-8116151 N8334ZUfly Vi LLC · St Thomas, VIBuilt 1981 · S/N 28-8116152 N83354Stephl Matt J · Anchorage, AKBuilt 1976 · S/N 18-7609094 N83358Minikey Jack DBA · Stanton, MIBuilt 1976 · S/N 18-7609098 N83359Magalsky Jacob J · Wilsall, MTBuilt 1976 · S/N 18-7609099 N8335EMillheim Roger L · Frankston, TXBuilt 1959 · S/N 1513 N8335WHiatt Ronald G · Forestburgh, NYBuilt 1965 · S/N 28-2516 N83362Magnuson Robert L Jr · Mc Grath, AKBuilt 1976 · S/N 18-7609092 N83367Peterson Leland C Co Trustee · Anchorage, AKBuilt 1976 · S/N 18-7609100 N83368High Mountain Air LLC · Missoula, MTBuilt 1976 · S/N 18-7609091 N8336GGolden Age N8336g LLC · Norwalk, IABuilt 1981 · S/N 28-8190167 N8336PWyatt Gary D · Sun City West, AZS/N 24-3590 N8336RSmith Gerald A Trustee · Bow, NHBuilt 1966 · S/N 28-22209 N8336WJd Aviation LLC · Omaha, TXBuilt 1965 · S/N 28-2518 N83378Aldridge Brett A · Soldotna, AKBuilt 1976 · S/N 18-7609105 N83379Nei Jeffrey G · Bemidji, MNBuilt 1976 · S/N 18-7609107 N8337EC & S Aerial Photography LLC · Ponca, NEBuilt 1959 · S/N 1515 N83381Fishfull Thinking LLC · Cordova, AKBuilt 1976 · S/N 18-7609111 N83386Treit Marlowe · Aurora, ORBuilt 1976 · S/N 18-7609112 N8338CBean Eric J · Canton, NCBuilt 1976 · S/N 28-7625103 N8338DPlant Galen M · Crown Point, INBuilt 1981 · S/N 28-8116156 N8338LTreimer Aviation LLC · Davenport, IABuilt 1968 · S/N 17256538 N8338RMarshall Rodney V · Riverton, UTBuilt 1966 · S/N 28-22211 N8338WL A S LLC · Fort Leavenworth, KSBuilt 1965 · S/N 28-2520 N83392Guy James L P · Wasilla, AKS/N 18-7609117 N83394Hard Luck Aviation LLC · Tok, AKBuilt 1976 · S/N 18-7609118 N83395Jorgensen Spike C · Tok, AKBuilt 1976 · S/N 18-7609119 N83397Gila Aviation Co LLC · Whitefish, MTBuilt 1976 · S/N 18-7609120 N8339CEberle Michael Thomas · Plato, MOBuilt 1975 · S/N 28-7615089 N8339DLd Flight LLC · Houston, TXBuilt 1982 · S/N 28-8316030 N8339LRohrbaugh David J · Oakland, MDBuilt 1968 · S/N 17256539 N8339RGonzalez Karina · Bloomfield, NJFirst renewal noticeBuilt 1966 · S/N 28-22213 N8339WYoung Stanley K · Edmond, OKBuilt 1965 · S/N 28-2522

Back to AD 79-10-03 R2