OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N6014YBackscheider Eric D · La Follette, TNBuilt 1997 · S/N 24367N6014ZSimpson Alena A · Blue Eye, MOBuilt 1979 · S/N M-2141N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147N6015LWade Rolla R · Kingsport, TNBuilt 1972 · S/N AA5-0115N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141N6015UN6015u LLC · Lakeview, NCS/N M-2135N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145N60165Caballero Arturo C · Clute, TXBuilt 1979 · S/N M-2145N6016DWells Roger M · Stratford, TXBuilt 1956 · S/N 22-4669N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156N6016XBeland Michael R · Maiden, NCS/N 1650N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N6017WKarg James R · Paradise, TXBuilt 1964 · S/N 28-20017N6018DBader Ronald W · Montrose, MIBuilt 1956 · S/N 22-4671N6019DKuper Carl J II · Dalhart, TXBuilt 1956 · S/N 22-4672N601EAExecutive Air Transport Inc · Norton Shores, MIBuilt 1978 · S/N 28-7916124N601FTSanson Paul H · Deland, FLBuilt 1989 · S/N 2841195N601LANicely Juan · Mount Vernon, KYS/N 1473N601PAMendenhall Michael L · Douglasville, GABuilt 1977 · S/N 17269030N601RDPichon Dean M · Essex, VTBuilt 2001 · S/N 2981N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71N601RVFly Right LLC · Reno, NVBuilt 2003 · S/N 60325N601VSJireh Wings LLC · Las Vegas, NVS/N 2036LN6020DDufreche David S · Sanger, TXBuilt 1956 · S/N 22-4673N6020LJenkins David B · Hemet, CABuilt 1972 · S/N AA5-0120N6020QN6020q LLC · Jensen Beach, FLBuilt 1965 · S/N 3231N6020WBritton Jeffrey A · Accident, MDBuilt 1964 · S/N 28-20020N6021QR&L Aviation Inc · Philadelphia, PAS/N 3232N6021WA&C Aviation LLC · Lawrenceville, GABuilt 1964 · S/N 28-20021N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6022SAhlberg Merick D · Eagle River, AKBuilt 1979 · S/N M-2156N6022WDelgado Mario J · Baldwin Park, CAS/N M-2153N6023DBusta Daniel N · Los Angeles, CABuilt 1956 · S/N 22-4676N6023XSytsma Douglas A · Canton, MIBuilt 1960 · S/N 1611N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130N6024DPunt Matthew L · Wasilla, AKBuilt 1956 · S/N 22-4677N6024WWhite Pelican LLC · Union City, TNBuilt 1964 · S/N 28-20024N60250Camelot Aviation LLC · Wilmington, DEBuilt 1969 · S/N 15070171N6025WSocal Flights LLC · Simi Valley, CAS/N 28-20025N6026GAce Pdr LLC · Lewisville, TXS/N 2073N6026LDolan Kathleen M · Sunnyside, WABuilt 1972 · S/N AA5-0126N6026QKosmata Charles C · Mcpherson, KSBuilt 1965 · S/N 3234N6027DSnyder Logan J · Wasilla, AKBuilt 1956 · S/N 22-4680N6028XHarnagel Duard R · Scottsdale, AZBuilt 1960 · S/N 1618N6029DRonnie L Tremain · Sherwood, ORBuilt 1956 · S/N 22-4682N6029QHill John T · Saint Augustine, FLBuilt 1965 · S/N 3235N6029WWalsh Robert D · Somerset, CABuilt 1964 · S/N 28-20029N602CBWray David A · Louisville, KYS/N 446-18-1830N602EPJones Theodore R · Prospect, KYBuilt 2002 · S/N 70382
Back to AD 79-10-03 R2