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.

N856EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12674N856FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13460N8570BPilot Coaches LLC · Little Falls, MNS/N 36270N8570GGreenville Pilots Association Eaa Chapter 1382 · Greenville, ILS/N 15062670N8570JBitikofer Brent · Kansas City, KSS/N 15066470N8570QTwo O Six Inc · Fort Myers, FLBuilt 1976 · S/N U20603426N8570THeuett Clint James · Asotin, WABuilt 1959 · S/N 52470N8571JRoam Gary A · Venice, FLBuilt 1967 · S/N 15066471N8571SStevenson Intermountain Seed Inc · Ephraim, UTBuilt 1965 · S/N 18256671N8571UBell Charles M DBA · Warsaw, NYBuilt 1965 · S/N 17252471N8571XRegistered aircraftBuilt 1963 · S/N P17257171N8572RReese Owein · Glen Rock, NJBuilt 1964 · S/N 205-0549N8572SPaulan Beverly S · Antioch, ILBuilt 1965 · S/N 18256672N8572TAerial Wayfarer LLC · San Antonio, TXS/N 52472N8572USkyline Aviation Solutions LLC · Grosse Ile, MIBuilt 1976 · S/N 15077952N8573GFichtner Eric Lowell Russell · Concord, NCS/N 15062673N8573S182 Flight Corp · Bronx, NYBuilt 1965 · S/N 18256673N8574JHubenthal William L · Carbondale, ILBuilt 1967 · S/N 15066474N8574XDiscover Aviation Center LLC · Elyria, OHBuilt 1963 · S/N P17257174N8575GAero Services Lc · Woods Cross, UTS/N 15062675N8575SDallas William J · Eastsound, WABuilt 1965 · S/N 18256675N8575TChristensen Del S Trustee · Friendswood, TXBuilt 1959 · S/N 52475N8575UVermillion County Flying Club · Danville, ILBuilt 1965 · S/N 17252475N8576BRomeo Delta Inc · Elsie, MIBuilt 1957 · S/N 36276N8576GSchaefer John · Liberty Hill, TXBuilt 1966 · S/N 15062676N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432N8577GLakey Robert E · Arlington, TXBuilt 1965 · S/N 15062677N8577SRegistration Pending · Concord, GARegistration pendingBuilt 1965 · S/N 18256677N8578JParagon Aviation LLC · Reading, PABuilt 1967 · S/N 15066478N8579SHopp Gregory R · Columbus, OHBuilt 1965 · S/N 18256679N8579TGoldschmidt Scott · Cottonwood, CABuilt 1960 · S/N 52479N8579UStueckradt Steve · Ankeny, IABuilt 1965 · S/N 17252479N857AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12126N857NTSmeltz Kent · Dornsife, PABuilt 2018 · S/N 18283059N857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeBuilt 2000 · S/N 18280857N857SPSoutheastern Oklahoma State University · Durant, OKS/N 172S8115N8580BB&R Aircraft LLC · Wadsworth, OHBuilt 1958 · S/N 36280N8580GRhoat William E · Paso Robles, CAFirst renewal noticeBuilt 1965 · S/N 15062680N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436N8580TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 52480N8580UBaker Shane A · Marshall, WIBuilt 1965 · S/N 17252480N8581FAccurate Aero LLC · Minden, NVS/N 51956N8581SBlack Samuel W · Kennesaw, GABuilt 1965 · S/N 18256681N8581ULarkin John · Cambridge, IDBuilt 1965 · S/N 17252481N8581XRegistered aircraftBuilt 1963 · S/N P17257181N8582BHousley William M · Jasper, ALS/N 36282N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482N8582UMartin Livestock LLC · Ione, CABuilt 1965 · S/N 17252482N8583SDevillier Roland James · Winnie, TXBuilt 1965 · S/N 18256683N8583UVon Burg Jon B · Hull, ILS/N 17252483
Back to AD 79-10-14 R1