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.

N8595GLazy 8 Flying Service LLC · Polson, MTBuilt 1965 · S/N 15062695N8595UMoore James F Jr · Alexandria, KYS/N 17252495N85965Burn Gray P · North Stonington, CTBuilt 1968 · S/N 337-1037N8596JNelson David D · Mercer, PABuilt 1966 · S/N 15066496N8596UAtlanta Air Academy LLC · Kennesaw, GABuilt 1965 · S/N 17252496N8597UMrd Aero LLC · Manheim, PABuilt 1965 · S/N 17252497N85988Wilson Miles · Mcminnville, TNBuilt 1973 · S/N 18261907N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453N8598SBradley Christopher J · Left Hand, WVBuilt 1965 · S/N 18256698N8598TFoster Jacob D · Parker, COBuilt 1960 · S/N 52498N8598UMcclay Andrew · Baker City, ORBuilt 1965 · S/N 17252498N85992Mildenburger Frederick E · Scottsburg, INBuilt 1969 · S/N 337-1051N8599BPruett Mike A · Springdale, ARBuilt 1958 · S/N 36299N8599GBoatright Michael L · Live Oak, FLBuilt 1966 · S/N 15062699N8599QForbes Paul J · Anchorage, AKBuilt 1976 · S/N U20603454N8599SMcclung Malcolm J · Ripon, WIBuilt 1966 · S/N 18256699N8599TRegistered aircraftBuilt 1960 · S/N 52499N859ALAms Aviation LLC · South Bend, INBuilt 1979 · S/N U206-04888N859BABarr Air Patrol LLC · Mesquite, TXS/N 18268080N859CPN859cp LLC · Boynton Beach, FLBuilt 1999 · S/N 17280540N859DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12568N859DLBryant Charles Martel · Dallas, TXBuilt 1976 · S/N 18503134N859JANational Aircraft Leasing · Greenville, DEBuilt 2009 · S/N 18282173N859JTRainier Flight Service LLC · Renton, WABuilt 2019 · S/N 172S12246N859SPJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8762N859ZSeneca Flyers Inc · Waterloo, NYS/N 56306N85ACSusten LLC · Austin, TXBuilt 1975 · S/N 18264232N85AJBha Leasing Inc · South Portland, MEBuilt 1977 · S/N 18503424N85BBennett Dennis Lane Jr · Hastings, MIBuilt 1957 · S/N 33979N85BPPearce William · Grants Pass, ORBuilt 1961 · S/N 185-0183N85CFSutton Aircraft Salvage LLC · Palmer, AKFirst renewal noticeBuilt 1971 · S/N 18501904N85DTPolashenski Christopher · Fairbanks, AKBuilt 1978 · S/N 18503474N85EFRegistered aircraftBuilt 1974 · S/N 18263109N85FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12949N85GH185f LLC · East Troy, WIBuilt 1975 · S/N 18502655N85GKSale Reported · Yonkers, NYSale reportedBuilt 1962 · S/N 17249512N85JAFrequency Change Aviation Services Inc · Nashville, TNS/N 17273313N85JWWhittington Robert W · Blackwell, OKBuilt 1968 · S/N 17257686N85JXKahonees Air Service LLC · Bozeman, MTBuilt 1973 · S/N 18502298N85KAMancini Christopher S · Houston, TXBuilt 1977 · S/N 18503404N85LCCoyote Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502643N85LZJacques Jerry J · Iliamna, AKBuilt 1975 · S/N 18502777N85NEvans Thomas P · Hollow Rock, TNBuilt 1966 · S/N 18257256N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774N85QAmiculum LLC · Black Eagle, MTBuilt 1978 · S/N 18503703N85RN85 Romeo Group Lp · Wildwood, MOBuilt 1978 · S/N 18266494N85SJSweet Jesus LLC · Ridgely, MDBuilt 1959 · S/N 52280N85SNSn Inc · Seattle, WAS/N 18501844N85SSCornelius John W · Elgin, TXBuilt 1966 · S/N 15064568N85TBurbanks Travis · Woodland Hills, CABuilt 1960 · S/N 18253094
Back to AD 79-10-14 R1