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.

N79463Riley Richard G Jr · New Brighton, PABuilt 1973 · S/N 18261825N79467Horschel Duane D · Springville, NYBuilt 1973 · S/N 18261828N79468Whitmire Alan K · Canyon Lake, TXS/N 17258113N7946BBrock Raymond Richard · Crescent, IAS/N 29746N7946FPaul Paulson A · Kipnuk, AKBuilt 1966 · S/N 15064046N7946GRegistration Pending · Beach City, TXRegistration pendingBuilt 1970 · S/N 17259646N7946TWright Anthony · Tallahassee, FLS/N 56646N7946UUpper Aircraft International LLC · Titusville, FLBuilt 1964 · S/N 17251946N79472Frey Michael L III · Waco, TXBuilt 1969 · S/N 17258115N79473Tnw Aviation LLC · Clinton, ARS/N 17258116N79475Registered aircraftBuilt 1969 · S/N 17258118N79477Shipley David L · Yates City, ILBuilt 1969 · S/N 17258120N79478Fusano Lisa A · La Crescenta, CAS/N 17258121N79479Larue Mark C · Leander, TXBuilt 1969 · S/N 17258122N7947BJames Bobby F · Bloomfield, INBuilt 1957 · S/N 29747N7947GStearman Field Aircraft Repair LLC · Benton, KSBuilt 1970 · S/N 17259647N7947THarris Billy M · Waco, TXBuilt 1960 · S/N 56647N7947ZBouchard Jamie Claude · Berwick, MES/N 15060047N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127N7948BGruber Barbara L · Centreville, VABuilt 1957 · S/N 29748N7948TJolley Jonas D · Woodstock, GABuilt 1960 · S/N 56648N7948ZRlh Montana LLC · Helena, MTBuilt 1963 · S/N 15060048N79493Bounds Trucking LLC · Faison, NCS/N 17258130N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133N7949BHeffron Jacob L · Little Falls, MNS/N 29749N7949EPurstell Kevin · Burnt Hills, NYBuilt 1959 · S/N 17749N7949FMaciol Michael W M D · Pelham, NYBuilt 1973 · S/N A1500452N7949TMacleod Brian D · Maumee, OHBuilt 1960 · S/N 56649N7949ZFlores Carah L · Perris, CABuilt 1963 · S/N 15060049N794CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282127N794CTCarolina Custom Farm Equipment LLC · Wilson, NCBuilt 1965 · S/N 17252598N794FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13174N794RGFb Aviation LLC · Minot, MEBuilt 1999 · S/N 18280538N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138N7950BBobka Christian · Apple Valley, MNBuilt 1957 · S/N 29750N7950EGanskop Brandy D · Flaxton, NDBuilt 1959 · S/N 17750N7950GRotormate LLC · Royse City, TXBuilt 1970 · S/N 17259650N7950TSchroeder Henry G · Lacombe, LABuilt 1960 · S/N 56650N7950UBowden James E Jr · Eufaula, ALS/N 17251950N79513Kalman Engineering Inc · Pekin, ILBuilt 1969 · S/N 17258142N79514Galaxy Aviation LLC · Nantucket, MABuilt 1976 · S/N 17268134N7951BRocky Creek Jbd Inc · Boca Grande, FLBuilt 1957 · S/N 29751N7951TClair Brent A · Loraine, ILBuilt 1960 · S/N 56651N7951URegistration Pending · New Smyrna Beach, FLRegistration pendingS/N 17251951N79522729 Air LLC · Las Vegas, NVBuilt 1973 · S/N 18261832N79526Evink Bradley D · North Branch, MNBuilt 1969 · S/N 17258151
Back to AD 79-10-14 R1