OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N407EBAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11438N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234N407MD9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12764N407SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12588N4080DCrane Gary W · Gig Harbor, WABuilt 1957 · S/N 34780N4080FGoggans John L · Mansfield, MOBuilt 1958 · S/N 36980N4080YPanama City Cycles Inc · Panama City, FLBuilt 1961 · S/N 1850280N4081DEarl Tim G · Plymouth, CAS/N 34781N4081VLark Thomas S · Coppell, TXBuilt 1975 · S/N 15076694N4082DSharp Nicholas · Valdez, AKBuilt 1957 · S/N 34782N4083DAerohawk Aviation Inc · Idaho Falls, IDBuilt 1957 · S/N 34783N4083UKadlecovic Martin · Prescott, AZBuilt 1964 · S/N 15061483N4085UHilderbrand Timothy S · Chicora, PABuilt 1965 · S/N 15061485N4085VGeorge Daniel W · Reynoldsburg, OHBuilt 1948 · S/N 18417N4086DThompson George M · Fairbanks, AKBuilt 1957 · S/N 34786N4086FShelton Joseph G · Kingman, AZBuilt 1958 · S/N 36986N4086JBell Robert A Jr · Scotland Neck, NCBuilt 1966 · S/N 15065386N4086VBoyd Darrell M · Claremore, OKBuilt 1975 · S/N 15076695N4087VYakima 65 N Flying Club · Yakima, WABuilt 1948 · S/N 18419N4088DIron Horse Aviation LLC · Omak, WABuilt 1957 · S/N 34788N4088JLampasona Brendan T · Citrus Springs, FLBuilt 1966 · S/N 15065388N4088VSlezak Daniel S · Santa Margarita, CABuilt 1975 · S/N 15076696N4089DGaffney Justin L · Arcata, CABuilt 1958 · S/N 34789N4089VIhlenfeld Mark A · Owatonna, MNBuilt 1948 · S/N 18421N408CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282446N408EAMagnell Gregory P Trustee · Vicksburg, MIBuilt 1998 · S/N 18280139N408EPAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11439N408ESRussell Robert Q · Genoa City, WIBuilt 1997 · S/N 17280226N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075N408LBM & G Aircraft Management LLC · Englewood, COBuilt 2012 · S/N 172S11157N408LJHuston Craig C · Keokuk, IABuilt 1975 · S/N 18264147N408RStone Aviation LLC · Cusick, WABuilt 1954 · S/N 31149N4090FFox Aero Club · Catawba, NCBuilt 1958 · S/N 36990N4090HSouthern Air Transport Services LLC · Dover, DEBuilt 1969 · S/N 18052083N4092VGroves Donald L · Butler, PABuilt 1975 · S/N 15076697N4093DZito Nick D · Ellensburg, WABuilt 1957 · S/N 34793N4093JGarcia Joseph Donald · Okeana, OHS/N 15065393N4094DManker Lance M · North Platte, NEBuilt 1957 · S/N 34794N4094FSchupbach Robert D · Clearwater, FLS/N 36994N4094JSquires Janis R · Amherst, OHBuilt 1966 · S/N 15065394N4094VGoodwin Jefferson J · Dolan Springs, AZS/N 18426N4095AValiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 18503910N4095DRedfern Ronnie M · Fairbanks, AKBuilt 1957 · S/N 34795N4095JParks Richard C · Salem, MOBuilt 1966 · S/N 15065395N4096DSkydive Cape Cod Inc · Caddo Mills, TXBuilt 1958 · S/N 34796N4096FGood John G · Weatherford, TXBuilt 1958 · S/N 36996N4096VWtw Air LLC · Houston, TXBuilt 1977 · S/N R1722272N4097FWadsworth Tom R · Roswell, NMBuilt 1958 · S/N 36997N4097MN4097m LLC · Boynton Beach, FLBuilt 1998 · S/N 17280322N4097PBarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280168
Back to AD 79-10-14 R1