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.

N9244GTrover Nicholas · Chico, CAS/N 18260784N9244HCoachron Investments LLC · Grosse Ile, MIBuilt 1975 · S/N 17266042N9244UCairo Flying Club Inc · Cairo, ILBuilt 1976 · S/N 15078194N92452Meredith Judyann Cote · Lexington, KYBuilt 1969 · S/N 18260208N92456Watt Robert B · Mount Vernon, ORBuilt 1969 · S/N 18260210N92458Selby James T · Valley Center, CAS/N 18260211N92459Warren Ronald Mark · Elizabeth City, NCBuilt 1969 · S/N 18260212N9245BHitt Lonnie D · Gatesville, TXBuilt 1958 · S/N 55045N9245GHerb Liverett Companies Inc · Rio Linda, CABuilt 1971 · S/N 18260785N9245TCook Erik C · Redmond, ORBuilt 1960 · S/N 50745N9245UTaylor James R · Murfreesboro, TNS/N 15078195N9245XLeupp John R · Taylors, SCBuilt 1961 · S/N 18253645N92460Wings 182 LLC · Genoa, NVBuilt 1969 · S/N 18260213N92461Flying Six Inc · Lander, WYBuilt 1970 · S/N 18260214N92463Sopatyk Brian D · Boise, IDBuilt 1970 · S/N 18260215N92464Tuschka Ted H · Donnelly, IDBuilt 1970 · S/N 18260216N92466Pierce Bradley D · Waco, TXBuilt 1970 · S/N 18260218N92467Jacobsen Thomas R · Auburn, CABuilt 1970 · S/N 18260219N9246CReynolds Cody P · Sun City, CABuilt 1955 · S/N 31345N9246NWestways Aviation LLC · El Cajon, CAS/N 17269246N9246UArtemis Aviation Group LLC · Kalispell, MTBuilt 1976 · S/N 15078196N9246XGrodi Leslie A · Monroe, MIBuilt 1961 · S/N 18253646N92471Shoemaker Floyd · Oneida, TNS/N 17261579N92472Boyle Neal · Beaver Island, MIBuilt 1970 · S/N 18260222N92479Hill Top Aviation LLC · Humboldt, SDBuilt 1970 · S/N 18260224N92481Barraza Construction LLC · Saint Joseph, LABuilt 1970 · S/N 18260225N92486Big E LLC · Lemoore, CABuilt 1970 · S/N 18260227N9248BJackalope Aviation LLC · Bellingham, WABuilt 1958 · S/N 55048N9248CRegistered aircraftBuilt 1955 · S/N 31347N9248XPadua Corp · Wilmington, DEBuilt 1961 · S/N 18253648N92492Meger Daniel F · Lincolnton, NCBuilt 1970 · S/N 18260229N92495Welborn Mark Grant · Boonville, NCBuilt 1970 · S/N 18260231N9249AZabowski Alan G · Belvidere, NJBuilt 1949 · S/N 19010N9249BCoull Jennifer · Easton, PABuilt 1958 · S/N 55049N9249HGencur Paul A · Hudson, OHBuilt 1975 · S/N 17266044N9249RGreat Plains Applications LLC · Slayton, MNBuilt 1975 · S/N 18802187TN924AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13561N924ASA2g International LLC · San Juan Capo, CABuilt 1979 · S/N 33701908N924AZN924az LLC · Miami, FLBuilt 2025 · S/N 172S13282N924CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8912N924LPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2002 · S/N 172S9204N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509N92503Harper Bryan K · Junction City, ORBuilt 1976 · S/N 18503155N9250VFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11182N9250XRapchak Barbara A · Batavia, ILBuilt 1961 · S/N 18253650N92519Flory Air LLC · Culdesac, IDBuilt 1970 · S/N 18260241N9251AMills Don T · Fairfield, CABuilt 1949 · S/N 19012N9251BBurke Charles M · Ocala, FLFirst renewal noticeBuilt 1958 · S/N 55051N9251UCarpenter James M · Marion, ARS/N 15078201N9251XWhite Ronald V · Overgaard, AZBuilt 1961 · S/N 18253651
Back to AD 79-10-14 R1