AD 79-10-14 R1

Registered aircraft · 56,582

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-14-R1')
    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-14-R1')
  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.

N8757SManna Anthony G · Hanover, MABuilt 1965 · S/N 15062057N8757ULewis County Flying Club · Lewistown, MOBuilt 1965 · S/N 17252661N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511N8758ZBellows Paul F · Vancouver, WABuilt 1968 · S/N P206-0558N8759SCrowell Jeremy M · Arlington, WABuilt 1965 · S/N 15062059N8759TBlack Clifton D · Newnan, GABuilt 1960 · S/N 52659N8759UKelly Cynthia · Sealy, TXBuilt 1965 · S/N 17252663N8759XGrald Jonathan A · Goshen, NYBuilt 1961 · S/N 18253159N8759ZHelin Bruce A Trustee · Flagstaff, AZBuilt 1968 · S/N P206-0559N875CDBoca Pilot LLC · Delray Beach, FLS/N 17264899N875CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281871N875MAGould Norman L Jr · Saunderstown, RIBuilt 1967 · S/N 15067754N875PJEj Air LLC · Bel Air, MDBuilt 2016 · S/N 18282460N875RHGreat Lakes Aviation LLC N875rh · Antioch, ILBuilt 1978 · S/N R1722964N8760BManaged Aviation Inc · The Villages, FLBuilt 1957 · S/N 36460N8760QCarcioppolo Joseph A · Auburn Twp, OHS/N 18503768N8760TMccandless Aviation LLC · Omaha, NEBuilt 1960 · S/N 52660N8760UReid Gary M · Medford, ORS/N 15077982N8761TProsystems Consulting LLC · Saguache, COS/N 52661N8761USmith Dustin T · Jasper, GABuilt 1965 · S/N 17252665N8761ZHaag Walter G · Fall City, WABuilt 1968 · S/N P206-0561N8762TCrook Brady G · Bandon, ORBuilt 1960 · S/N 52662N8762UBelli Christopher J · Oregon, OHBuilt 1965 · S/N 17252666N8763BMellen Roger B · Roseburg, ORBuilt 1957 · S/N 36463N8763GElliott Norman C · Stillwater, OKBuilt 1966 · S/N 15062863N8763QArtic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1976 · S/N U20603516N8763SClinton Richard C · Fair Oaks, CAS/N 15062063N8763XRegistered aircraftBuilt 1961 · S/N 18253163N8763ZMacdonald John R · Vancouver, WABuilt 1968 · S/N P206-0563N8764GStrait Media LLC · Anchorage, AKS/N 15062864N8764XAdventist World Aviation · Wilson, NCBuilt 1961 · S/N 18253164N8765URebel Metals LLC · Croydon, NHBuilt 1976 · S/N 15077983N8766GGascho Wendell M · Bridgewater, VABuilt 1966 · S/N 15062866N8766XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1960 · S/N 18253166N8767TReppond Richard · Sage, ARBuilt 1960 · S/N 52667N8767XSmith Todd A · Duchesne, UTBuilt 1960 · S/N 18253167N87687Dittmer Dean C · Bennett, COBuilt 1967 · S/N R172-0248N8768MRegistered aircraftBuilt 1976 · S/N 18264636N8768RBaker Scott R · Arroyo Grande, CABuilt 1968 · S/N 18258978N8768TCarter Douglas A · Tower, MNBuilt 1960 · S/N 52668N8768UWright Roland P · Detroit, MIBuilt 1965 · S/N 17252672N8768XBeachy Phil · Bonners Ferry, IDBuilt 1960 · S/N 18253168N8769GHeli Thrills LLC · Wills Point, TXBuilt 1966 · S/N 15062869N8769TCopper River Airmotive LLC · Copper Center, AKBuilt 1960 · S/N 52669N8769XOmega I Corp Inc · Middletown, DEBuilt 1961 · S/N 18253169N8769ZFox Stanton C · Fairfax, VABuilt 1978 · S/N 177RG1358N876CGGreen Carlton · Carmel Valley, CABuilt 1962 · S/N 18253734N876EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13523N876MGAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12709N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844
Back to AD 79-10-14 R1