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.

N7104VPorzillo Patrick H · Newburg, MDBuilt 1974 · S/N 200028N7104WRegistration Pending · Shelbyville, TNRegistration pendingBuilt 1962 · S/N 28-891N7105LTolbert John M · Jacksonville Beach, FLBuilt 1973 · S/N AA5-0405N7105UMolter Roy G · Shelbyville, INBuilt 1964 · S/N 2735N7105WDeibert Dale A · Herreid, SDBuilt 1962 · S/N 28-893N7106BSlaughter D Wayne · Farmsville, NCBuilt 1956 · S/N 22-4325N7106DHarris & Associates Inc · Scottsdale, AZBuilt 1957 · S/N 22-4964N7106UTappon Wayne A · Ladysmith, WIBuilt 1964 · S/N 2736N7106WGriffin Jim T · Tunnel Hill, GABuilt 1962 · S/N 28-894N7107LYellowjet Flying Club LLC · Mukilteo, WAS/N AA5-0637N7107UJohnson Kenneth D · Camdenton, MOBuilt 1964 · S/N 2765N7107WCaufield Dennis R · Carl Junction, MOBuilt 1962 · S/N 28-895N7108DWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1957 · S/N 22-4966N7108GLakes Area Aviation LLC · Little Falls, MNS/N 17258808N7108LWeiland Scott J · Howe, INBuilt 1973 · S/N AA5-0408N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408N7108RChristian Mark A · South Point, OHBuilt 1966 · S/N 28-21805N7108WRed Rock Flying School LLC · Mesa, AZS/N 28-896N7109BEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4326N7109LSimpson Brian · Indian Trail, NCS/N AA5-0409N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409N7109UOyler Joseph B · Kokomo, INBuilt 1964 · S/N 2739N7109WV1 Air Inc · Hibbing, MNS/N 28-897N710BJBluebird LLC · Vestavia, ALBuilt 2003 · S/N 60062N710CBPruitt Ron A · Stoneville, NCBuilt 1980 · S/N 1N710EHRatcuffe Howard Clark · Huntsville, UTBuilt 2000 · S/N 23446N710GMaj Enterprises LLC · Missoula, MTBuilt 2013 · S/N 460N710LGCollette John D · Las Vegas, NVS/N 710N710RDPurll Samuel B · Mechanicsville, MDBuilt 1966 · S/N 28-21809N7110BSeven-Eleven Brick Inc · Dalton, MNBuilt 1956 · S/N 22-4327N7110PTobias Gregory L · Ottawa Lake, MIBuilt 1960 · S/N 24-2267N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410N7110RQuale Eric L · Everett, WABuilt 1966 · S/N 28-21806N7111DKeyt Jeffrey D · New Providence, NJBuilt 1957 · S/N 22-4969N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101N7111RGreen Michael W · Helena, ARS/N 28-21810N71128Eastern Stearman Inc Trustee · Leesburg, VABuilt 1972 · S/N 28-7225450N7112CEmbry Vantha C · Knoxville, TNS/N 28-7690056N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812N7112KHamann Hunter R · Spokane, WABuilt 1950 · S/N 18-329N7112LDoskicz Harry N · Slatington, PAS/N AA5-0612N7112RMarshall Air LLC · Bellevue, MIBuilt 1966 · S/N 28-21811N7112WKeesee Bill · Meadow, TXBuilt 1962 · S/N 28-903N7113DN7113d LLC · Ardmore, OKBuilt 1957 · S/N 22-4971N7113LBlanton Ronald · Lascassas, TNBuilt 1974 · S/N AA5-0675N7113PWallace Lonnie Roy · Charlotte, NCBuilt 1960 · S/N 24-1879N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413N7113RNewton Dennis E · Surprise, AZBuilt 1966 · S/N 28-21812N7113WHigh Flyers Inc · Benson, AZS/N 28-961N7114BShore Brian R · Carmichael, CABuilt 1956 · S/N 22-4331
Back to AD 79-10-03 R2