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.

N9287GCook Lynn H · Highland, UTBuilt 1971 · S/N 18260827N9287MRkm Leasing LLC · Greenwich, CTBuilt 2011 · S/N 172S11112N92881Patton Aviation LLC · Billings, MTBuilt 1970 · S/N 18260409N92886Lewis John E · Clayton, NJBuilt 1973 · S/N 17261640N92887Butler Aircraft Company · Walla Walla, WABuilt 1971 · S/N 18260413N92888Knudsen Wayne D · Dakota City, NEBuilt 1973 · S/N 17261641N92889Miller Andy · Marana, AZBuilt 1973 · S/N 17261642N9288CChase Michael D · Albuquerque, NMBuilt 1955 · S/N 31387N9288GPupkar Stephen B · Brookeville, MDS/N 18260828N92894Smith Rex H · Fort Bragg, CABuilt 1973 · S/N 17261644N92895Dana Eric B · Davidson, NCBuilt 1970 · S/N 18260418N9289BWoodstock Aircraft Services Inc · White Lake, NYBuilt 1958 · S/N 55089N9289GBolands North Inc · Binghamton, NYBuilt 1971 · S/N 18260829N9289XFull Send Aviation LLC · Fairview, TNS/N 18253689N928ASA2g International LLC · San Juan Capo, CABuilt 1979 · S/N 33701904N928CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282396N928FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10371N928HPeterson Michael A · White Salmon, WABuilt 1964 · S/N 17251734N928JCLatimer Nelson R · Oxnard, CABuilt 1977 · S/N 18265616N928LPMontana Freedom Riders LLC · Corvallis, MTBuilt 2001 · S/N 172S8928N928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeBuilt 1999 · S/N 17280785N928ZAFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12786N92908C-140 Company LLC · Pensacola, FLBuilt 1973 · S/N 17261647N9290BFitts Roger W · Independence, ORBuilt 1958 · S/N 55090N9290GPhillips Richard L · Vienna, OHBuilt 1971 · S/N 18260830N9290XPetrich John W · Metaline Falls, WABuilt 1961 · S/N 18253690N9291Henderson Charles B · Houston, TXBuilt 1980 · S/N 18265332N92912Hill Charles W · Russellville, ARBuilt 1970 · S/N 18260426N9291AEvans James · Tuolumne, CABuilt 1949 · S/N 19052N9291BVan Meerveld Dwight E · Poplar Grove, ILBuilt 1958 · S/N 55091N9291CMadland Patrick S · Anchorage, AKBuilt 1955 · S/N 31390N9291HDawson William F Jr · Port Hueneme, CABuilt 1975 · S/N 17266071N92922Perron Matthew B · West St Paul, MNBuilt 1970 · S/N 18260429N9292GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801448N9292HBlackhawk Flying Club Inc · Rockford, ILBuilt 1975 · S/N 17266072N92934Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1973 · S/N 17261650N92938Haney Christopher · Murrieta, CABuilt 1970 · S/N 18260435N9293CHayes Dennis Paul · Des Moines, IABuilt 1955 · S/N 31392N9293XRod Ricky L · El Cajon, CABuilt 1961 · S/N 18253693N92945Fla Inc · Wilmington, DEBuilt 1973 · S/N 17261655N9294BHall Justin E · York, NEBuilt 1958 · S/N 55094N9294CBoulder Valley Aviation Inc · Boulder, COS/N 31393N9294HWet Dreams LLC · Erwinna, PABuilt 1977 · S/N 18503428N9295BTow Dogs LLC · Kingman, AZS/N 55095N9295CLesmeister Dean J · Kindred, NDBuilt 1955 · S/N 31394N9295HMiami Seaplane Tours Inc · Miami, FLBuilt 1975 · S/N 17266075N9295TViking Custom Builders Inc · Anchorage, AKBuilt 1960 · S/N 50795N9296BColby Robert D · Bigfork, MTBuilt 1958 · S/N 55096N9296CDinstel Delbert F · Park City, MTBuilt 1955 · S/N 31395N9296GGreen Daniel C · Cedar Hill, TNBuilt 1971 · S/N 18260836
Back to AD 79-10-14 R1