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.

N3432CHolt Kristopher T · Wichita, KSS/N 26475N3432FBierschwale Land Co LLC · Mason, TXBuilt 1977 · S/N 21062407N3433CDiaz James R · Sullivan, OHS/N 26476N3433FVapor-Mist Sanitizing Systems · Boca Raton, FLS/N 18257433N3433JJason Webster · Orlando, FLBuilt 1967 · S/N 15066133N3433RAlty It Solutions LLC · Milan, MIBuilt 1967 · S/N 18258733N3433SKah Gretchen Wendel · San Francisco, CABuilt 1964 · S/N 18255833N34343Wright Wayne M · Chestertown, MDBuilt 1972 · S/N 17701772N34346Ball Donald · Hatfield, PABuilt 1972 · S/N 17701774N34348Pingree Properties LLC · Hampshire, ILBuilt 1972 · S/N 17701775N3434DWood Don Carlos III · Wilder, IDS/N 26977N3434RBurkhardt James · Brookings, SDBuilt 1967 · S/N 18258734N3434SDawsey Carl E · Long Beach, MSBuilt 1964 · S/N 18255834N3434UHale William R · Covina, CABuilt 1963 · S/N 18254834N34358Leap Aviation Inc · Wilmington, DEBuilt 1972 · S/N 17701777N3435CHarter Scott W · Estero, FLBuilt 1954 · S/N 26478N3435EBober Aviation Mountain Flying LLC · Hayesville, NCBuilt 1978 · S/N 17271547N3435FDickens Frank K · Moncure, NCS/N 18257435N3435JRegistration Pending · Florence, AZRegistration pendingBuilt 1967 · S/N 15066135N3435LYuknis Birch · Wasilla, AKS/N U206-0735N3435UJackson Terry W · Lewisburg, TNBuilt 1963 · S/N 18254835N3436DWalker Cindy R · Fairbanks, AKBuilt 1955 · S/N 26979N3436FChinik James G · Jacksonville Beach, FLBuilt 1967 · S/N 17700604N3437CYaiser James F · Saint Charles, MOBuilt 1954 · S/N 26480N3437DJohnson Christopher · Danville, INS/N 26980N3437FYankee Air LLC · Valdosta, GAS/N 18257437N3437RSmith Darrin M · Torrance, CABuilt 1968 · S/N 18258737N3437TRoberts John M · Mansfield, MOBuilt 1968 · S/N 17700737N3437YLanding Gear Works LLC · Renton, WAS/N 18051937N3438RDauenhauer Colby · Springtown, TXBuilt 1967 · S/N 18258738N3438SAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701784N3438UGrau Gary Wayne Jr · Yelm, WABuilt 1963 · S/N 18254838N3439CTroutman Charles W · Lincoln City, ORS/N 26482N3439DFord Corbin J · Bethel, AKS/N 26982N3439SProtsman Bryan D · Anchorage, AKBuilt 1964 · S/N 18255839N3439UFlycatcher Aviation LLC · Purcell, OKBuilt 1963 · S/N 18254839N343CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283310N343CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12344N343METhurman Craig Johnson · Ona, WVBuilt 2000 · S/N 18280739N343PTDiamond Head Aviation LLC · Kunia, HIBuilt 2005 · S/N 172S9831N343SASunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10477N343SPEight16 LLC · Lewes, DEBuilt 2003 · S/N 172S9498N34405Jj&R Aero LLC · Winchester, INBuilt 1972 · S/N 17701787N34407Registered aircraftS/N 17701788N3440DSimpson Don DBA · Bryan, TXBuilt 1955 · S/N 26983N3440JNoguess Michele R · Deming, NMBuilt 1967 · S/N 15066140N3440SLynch Chris A · Sedro Woolley, WABuilt 1964 · S/N 18255840N3440UPlane Joy LLC · Payson, AZBuilt 1963 · S/N 18254840N34411Jlh Aviation LLC · La Grange, TXBuilt 1972 · S/N 17701790N34413Mms Flight LLC · Shawnee, KSBuilt 1972 · S/N 17701791
Back to AD 79-10-14 R1