OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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
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.

N4088MRam Aviation LLC · Palmer, AKBuilt 1947 · S/N 12-3003SN4088PBas Part Sales LLC · Greeley, COS/N 23-1561N4089Indrebo Rick J · Livermore, CABuilt 1989 · S/N 173N408FHStevens William C · Ashland, MTBuilt 2012 · S/N 2012131N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112N40935International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 7603N40936Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 7592N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572N4093XBartholomeo Daryl A · Cleveland, OKBuilt 1971 · S/N 5193N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574N4095ZBreidenbach Bros Inc · Iliff, COBuilt 1964 · S/N 18-8108N40963Grant Matthew D · Alvord, TXBuilt 1974 · S/N 28-7415120N40965Portsmouth Flying Club LLC · Epsom, NHBuilt 1973 · S/N 28-7415121N40966Skytech Hc Ltd · Fredericksburg, OHBuilt 1973 · S/N 28-7415122N4096ESwiss John T · Anchorage, AKBuilt 1978 · S/N 18-7809064N4096XFoster Robert L Jr · Chandler, OKBuilt 1970 · S/N 5196N4096ZTurner Hal Eugene Jr · Tiburon, CAS/N 18-8110N40972Terry Aaron D · Glendale, AZS/N 28-7425196N4097XWilson Dane A · Church Point, LABuilt 1971 · S/N 5197N4097ZSullivan Daniel J · Long Lake, MNBuilt 1964 · S/N 18-8111N40984Four Zero Niner LLC · Granger, IABuilt 1973 · S/N 28-7425199N40987Besl Thomas J · Cincinnati, OHBuilt 1973 · S/N 28-7415126N4098FN4098f LLC · Ypsilanti, MIBuilt 1976 · S/N 28-7715004N4098XOstgard William R · Mims, FLS/N 5198N4098ZChant J Archie · Riverton, WYBuilt 1964 · S/N 18-8112N40993Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405159N4099EReel Chad · Wasilla, AKS/N 18-7809066N4099XMiller Aviation Group LLC · Coon Rapids, MNBuilt 1971 · S/N 5199N4099ZMayes Brett R · Williams, CABuilt 1964 · S/N 18-8113N409AFThomas Douglas M Jr · Blue Bell, PABuilt 1966 · S/N 28-21915N409MMStormer Isaac E · Curtis, WABuilt 1981 · S/N 154N40AWKlingbeil Mark T · Bottineau, NDBuilt 1999 · S/N 1452N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264N40CMKline Timothy L · Elverson, PABuilt 1987 · S/N 368N40CSSoloy L Chris · Wasilla, AKBuilt 1993 · S/N 1N40CZBeast Aero Consulting And Training LLC · Rosamond, CAS/N 0763N40DCWright Innovators LLC · Sebastian, FLBuilt 1988 · S/N 561N40DRRoss David R · Wakeman, OHBuilt 1991 · S/N DR-01N40DZSt. Bernard Aerial LLC · Kalispell, MTBuilt 1947 · S/N 12-2675
Back to AD 79-10-03 R2