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.

N751DWGaskins Frank E · Ashland, VABuilt 1981 · S/N 172RG1002N751ESHat Trick Aviation LLC · Dover, DEBuilt 2017 · S/N 18283014N751LSSimpson Simpson Inc · Castana, IABuilt 1954 · S/N 26462N751MCGrubb Kenneth W · Spring, TXBuilt 1963 · S/N 18051236N751MLQueensland Air LLC · Chicago, ILFirst renewal noticeBuilt 2001 · S/N 172S8754N751SDenson Mark T · Brenham, TXBuilt 1964 · S/N 18051424N751SPHagele Aviation LLC · Hillsboro, ORBuilt 2000 · S/N 172S8684N7520KGraber Raymond B II · Carson City, NVBuilt 1976 · S/N 18052659N7520MWhitehurst Funeral Chapels Inc · Los Banos, CABuilt 1959 · S/N 55820N7520THartley Chester E · Holts Summit, MOBuilt 1959 · S/N 47120N7520XSunwave Land LLC · Big Spring, TXBuilt 1960 · S/N 17248020N7521K5b 7b Aero LLC · Sandpoint, IDBuilt 1976 · S/N 18052660N7521TPerry Kenneth C Jr · Tucson, AZBuilt 1959 · S/N 47121N7521VLeslie Warren J · Sequim, WABuilt 1976 · S/N 177RG0818N7521XWainwright Donald W · Live Oak, FLS/N 17248021N7522KDewitt David B · Santa Rosa, CABuilt 1976 · S/N 18052661N7522MJohanson Mark E · Ivins, UTS/N 55822N7522TMoffitt Michael M · Wolcottville, INBuilt 1959 · S/N 47122N7522XZitterkopf Gary N · Casper, WYBuilt 1960 · S/N 17248022N7523GTriple J Aviation LLC · Mcconnelsville, OHBuilt 1970 · S/N 17259223N7523MW R Aviation Inc · Stigler, OKBuilt 1959 · S/N 55823N7523VTwc Aviation Services LLC · Merritt Island, FLBuilt 1975 · S/N 177RG0820N7524GBrandywine Sky Ramblers LLC · West Chester, PABuilt 1970 · S/N 17259224N7524MRange Shaun M · Brighton, MIS/N 55824N7524TBohn Flying LLC · Tijeras, NMBuilt 1959 · S/N 47124N7526GFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1970 · S/N 17259226N7526MHerning Benjamin N · Chugiak, AKS/N 55826N7526TJennen David · Erhard, MNBuilt 1960 · S/N 47126N7526XWeickum Lee A · Monroe, ORBuilt 1960 · S/N 17248026N7527KMark D Jones · Kremmling, COBuilt 1976 · S/N 18052662N7527MGarfoot William K · Verona, WIS/N 55827N7527TButcher Isis F · Marietta, OKBuilt 1959 · S/N 47127N7527XRankin Scott W · Kansas City, MOBuilt 1960 · S/N 17248027N7528GSale Reported · Rillito, AZSale reported, pending cancellationBuilt 1970 · S/N 17259228N7528XJewell Burton Connor Jacob · Pensacola, FLBuilt 1960 · S/N 17248028N7529GRibeiro Marcos F · Okeechobee, FLS/N 15074687N7529KBarak David T · Mountain Home, IDBuilt 1976 · S/N 18052663N7529NNoam Eli M · New York, NYS/N 18263232N7529U20 Awesome LLC · Albuquerque, NMBuilt 1962 · S/N 17248795N7529XBrown Anthony W · Sacramento, KYS/N 17248029N752DMS&M Holdings LLC · Oak Ridge, LABuilt 1962 · S/N 18254005N752DWFlying Start Aero Services LLC · Reno, NVBuilt 2001 · S/N 172S8752N752EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13553N752MFEpperly David J · New Richmond, WIBuilt 1974 · S/N 15075977N7530KMcmanigle Jeffrey M · Osakis, MNBuilt 1976 · S/N 18052664N7530TBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 47130N7530VNicolaou John G · San Ramon, CABuilt 1976 · S/N 177RG0827N7531NDreampad LLC · New York, NYBuilt 1974 · S/N 18263233N7531TJanke Gregory A · Lompoc, CABuilt 1959 · S/N 47131N7532NEagle Air LLC · Morgantown, WVBuilt 1977 · S/N U20603664
Back to AD 79-10-14 R1