OpenAirDocs.org
AD 79-10-03 R2

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

N787EBStith Michael P · Boiling Springs, SCS/N AA5-0819N787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeBuilt 1966 · S/N 18-8425N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025N787STCitabria N787st LLC · Reno, NVS/N 486-2004N787TKennedy Thomas M · Long Beach, CABuilt 2015 · S/N 0248N787WTSemper Supra Air LLC · Ashland City, TNBuilt 1978 · S/N 17271319N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774N7880GGhegan John · Wilmer, ALBuilt 1970 · S/N 17259580N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904N7881GSmith John T · Greenfield, INBuilt 1970 · S/N 17259581N7881WEast Crest Management LLC · Eastvale, CABuilt 1964 · S/N 28-1905N7882CKeck Joseph S · Las Vegas, NVS/N 28-7625087N7882VSlepian Isaac J · El Dorado Hills, CABuilt 1965 · S/N 2844N78830Frederick Wayne Schultz · Bradley, ILBuilt 1968 · S/N 17257782N78834Barron Ted L · Hoover, ALBuilt 1968 · S/N 17257783N7883DMeierotto Marty · Two Rivers, AKBuilt 1957 · S/N 18-6043N7883VFranks Gary E · Ponder, TXBuilt 1964 · S/N 2845N7883WStack Brian James · Paso Robles, CABuilt 1964 · S/N 28-1907N78842Helice Sarcelle LLC · San Antonio, TXBuilt 1968 · S/N 17257787N78846Aero Investors Lc · Jackson, MIS/N 17257788N78850Karpik Richard Paul · Grand Rapids, MNBuilt 1968 · S/N 17257790N78856Bedwell Christopher A · Paso Robles, CABuilt 1968 · S/N 17257791N78857Hunt Thornton Trevon · Aurora, COBuilt 1968 · S/N 17257792N7885DLindstrom Daniel G · Somerset, WIBuilt 1957 · S/N 18-6045N7885WCp Authority LLC · Poulsbo, WABuilt 1964 · S/N 28-1909N78861Wood Jeffrey A · Willis, TXS/N 253N78865Gingras Carl A · Avondale, COS/N 2880N78869Zullo Thomas L · Lindenhurst, NYBuilt 1964 · S/N 2884N7886GArctic Barnabas Ministries Inc · Kenai, AKBuilt 1970 · S/N 17259586N7886VLowenhaupt Michael J · Metairie, LABuilt 1964 · S/N 2848N7886WChelena Eric D · San Antonio, TXBuilt 1964 · S/N 28-1910N78871Rosenfeld Kristina M · Eureka, CABuilt 1964 · S/N 2886N78873Mesner Steven M · Tomah, WIBuilt 1964 · S/N 2888N78875Janssen Christopher R · Ankeny, IABuilt 1964 · S/N 2890N78877Obrien Garrett G · Sheep Ranch, CABuilt 1965 · S/N 254N7887GLandrum Erik · Austin, TXBuilt 1970 · S/N 17259587N7887WDepp Gregory B · Ft Worth, TXBuilt 1964 · S/N 28-1911N78880Coma Aviation LLC · Buckhannon, WVBuilt 1964 · S/N 2895N78882Triplat Bonnie E · Rosamond, CABuilt 1964 · S/N 2897N78884Cooke Daniel S · Kanarraville, UTBuilt 1964 · S/N 2899N78888Woodard Ben C · Truckee, CABuilt 1964 · S/N 2903N7888MMonpas Mark E · Anderson, CABuilt 2011 · S/N 72599N7888WLashinski Michael J · Monument, COBuilt 1964 · S/N 28-1912N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975N78890Edmondson Donald M · Harvest, ALBuilt 1964 · S/N 2905N78891Registered aircraftBuilt 1964 · S/N 2906N78892Rathbun Robert E · Maywood, MOS/N 2907N78893King Eugene A · Rch Palos Vrd, CABuilt 1964 · S/N 2908
Back to AD 79-10-03 R2