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.

N926CSHardee Philip S · Florence, SCBuilt 1957 · S/N 34471N926HMWestern Enterprise LLC · Pueblo, COBuilt 1974 · S/N 18502422N926JAMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10926N926LTHall Richard M · Scotland, SDBuilt 1968 · S/N 188-0347N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325N926NLRemington Robert J · Sheboygan Falls, WIS/N 172S8812N926TCTango Charlie LLC · Gig Harbor, WABuilt 1997 · S/N 18280052N926WBBender Walter F Jr · Virginia Beach, VABuilt 2000 · S/N 18280819N92701Kyllo Jeffrey K · Larimore, NDBuilt 1975 · S/N 18802070TN92704Gull Wing Flight LLC · Pt Pleas Bch, NJBuilt 1973 · S/N 17261605N92707Farquharson John L · Goldsby, OKS/N 18260319N9270GFrye Warren S · Galax, VABuilt 1971 · S/N 18260810N9270UYoung Orvel W · Maineville, OHBuilt 1976 · S/N 15078220N9270XCastle Rock Services LLC · Helena, MTBuilt 1961 · S/N 18253670N92711Intergard R&D LLC · Miami, FLBuilt 1973 · S/N 21060024N92712Pfister Michael J · Roanoke, ILBuilt 1970 · S/N 18260321N9271CSowder Douglas A · Spokane, WABuilt 1955 · S/N 31370N9271UWallis Bruce W · Kingwood, TXBuilt 1976 · S/N 15078221N92720Registration Pending · Champaign, ILRegistration pendingS/N 17261608N92722Bryant David A · Walhalla, SCBuilt 1973 · S/N 17261609N92725Tucker Kyler T · Cypress, TXBuilt 1970 · S/N 18260329N92726Gray Stanley Paul Jr · Temecula, CABuilt 1970 · S/N 18260330N9272BGyhra Bradley · Phenix City, ALBuilt 1958 · S/N 55072N9272GSena James H · Edmond, OKBuilt 1971 · S/N 18260812N9272HBlackbird 71 LLC · Rockford, ILBuilt 1975 · S/N 17266060N9272RFarrow Sammie N Jr · Cordele, GABuilt 1975 · S/N 18802200TN9272TAkers Dana M · Kingston, NHBuilt 1960 · S/N 50772N92739Mcmillin Michael C · Des Moines, IABuilt 1970 · S/N 18260335N9273GPlisko Aviation LLC · Beaufort, NCBuilt 1971 · S/N 18260813N92746Hansen Barbara · Armstrong, IAS/N 18260336N92747Wiles Donald · Shrewsbury, MABuilt 1973 · S/N 17261613N9274AOshinuga Anthony · Valley Center, CAS/N 19035N9274HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266062N9274XGawlik Leslie W · Reisterstown, MDBuilt 1961 · S/N 18253674N9274ZIsham Shane A · Wichita, KSS/N R172-0219N92750Rauton Ken · Temecula, CABuilt 1970 · S/N 18260339N92753Mccollum J R · Mount Pleasant, TXBuilt 1973 · S/N 17261614N92757Omegna Suzanne M · Spanaway, WABuilt 1970 · S/N 18260342N92758Wayne Alan A · Flowery Branch, GABuilt 1970 · S/N 18260343N92764Bernstein Jeffrey J · Swanton, MDBuilt 1970 · S/N 18260345N9276ABrandon Airways LLC · Bakersfield, CABuilt 1949 · S/N 19037N9276BKinberger Chris E · Louisville, KYBuilt 1958 · S/N 55076N9277Lynn William S · Jackson, MSBuilt 1953 · S/N 25964N92776Rivera Rivera Jose Manuel Trustee · Royal Palm Beach, FLBuilt 1970 · S/N 18260349N92777Macatawa Flyers Inc · Allegan, MIBuilt 1973 · S/N 17261616N9277ATibor W Farkas · Georgetown, TXBuilt 1949 · S/N 19038N9277CIrwin Phillip R · Parker, COBuilt 1955 · S/N 31376N9277HChorman Spraying LLC · Milton, DEBuilt 1975 · S/N 17266065N9277UPeters Airway LLC · Pratt, KSBuilt 1976 · S/N 15078227N92787Quade James C · Duluth, MNBuilt 1970 · S/N 18260356
Back to AD 79-10-14 R1