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.

N9676BAnselment Barney A · Polson, MTBuilt 1957 · S/N 32973N9676HErickson Paul F · Wasilla, AKBuilt 1978 · S/N 18503459N9676VCronsell Christopher A · Muskego, WIBuilt 1974 · S/N 17264456N9676XMoore Samuel B · Tucson, AZBuilt 1962 · S/N 21057976N96775Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276113N9677QKodiak Flying Club Inc · Kodiak, AKBuilt 1975 · S/N 17265761N96783Campbell George A · Aubrey, TXBuilt 1979 · S/N 18266851N96784Arnett William J · Heber Springs, ARBuilt 1979 · S/N 18266852N96788Lewis Garry L · Livingston, LABuilt 1984 · S/N 17276114N9678HBuckles Edward W II · Mechanicsburg, ILBuilt 1975 · S/N 17266307N9678QNorthgate Aviation Inc · Chico, CABuilt 1975 · S/N 17265762N96792N96792 LLC · Shrewsbury, MABuilt 1984 · S/N 17276115N96798Curl Kathryn Ann · Idaho Falls, IDS/N 18266856N9679AEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1984 · S/N 17276204N9679BRuehle Alex A · Denver, COBuilt 1957 · S/N 32976N9679QEagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17265763N9679XMurphree David A · Lake Saint Louis, MOBuilt 1963 · S/N 21057979N967AAWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260393N967AEKreil Curtis L · White City, ORBuilt 1962 · S/N 21057978N967CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281967N967DGPersinger Kenneth W · Fairbanks, AKBuilt 1956 · S/N 33567N967JRAmoroso Ricardo C · Powder Springs, GAFirst renewal noticeBuilt 1973 · S/N 17261816N967LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12037N967SAElizabeth City State University · Elizabeth City, NCBuilt 2002 · S/N 172S9067N96804Petecraft Aviation Services Inc · Plains, GABuilt 1979 · S/N 18266857N96808Hill William G Trustee · Laguna Niguel, CABuilt 1984 · S/N 17276116N96809Folsom Realty Group Inc · Greenville, MEBuilt 1984 · S/N 17276117N9680QAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17265764N9681Srividya Aviators LLC · North Brunswick, NJBuilt 1998 · S/N 18280233N96810Gordin Michael E · Lakeland, TNBuilt 1979 · S/N 18266859N96814Airplane Leasing LLC · Jupiter, FLFirst renewal noticeBuilt 1979 · S/N 18266860N9681AKablau Frank · Elroy, WIBuilt 1950 · S/N 15562N9681FSplashdown Aviation LLC · Dunedin, FLBuilt 1998 · S/N 18280268N9681HDavis Lester Jr · George West, TXBuilt 1975 · S/N 17266310N9681VCooperative Cross Roads Flying Club · Albuquerque, NMBuilt 1977 · S/N R1722346N9681XCentral Aviation LLC · White City, ORS/N 21057981N96821Tdm Aviators LLC · Madison, ALBuilt 1979 · S/N 18266863N9682APenfield George R · Shreveport, LABuilt 1950 · S/N 15403N9682HCloutblazer LLC · Sacramento, CABuilt 1975 · S/N 17266311N9682VBanks Michael R · Macon, MSBuilt 1974 · S/N 17264462N96836Visalia Flyers LLC · Visalia, CABuilt 1984 · S/N 17276121N96839Eastern Shore Aviation · Onancock, VABuilt 1984 · S/N 17276122N9683ARogers Wallace B · Salem, ORS/N 15404N9683BTita Enterprises LLC · Apex, NCBuilt 1981 · S/N 172RG0966N9683HCook Samuel Jordon · Thibodaux, LABuilt 1976 · S/N 17266312N9683QBering Capital LLC · Anchorage, AKS/N 17265767N9683TFroes Carlos D · Avondale, AZFirst renewal noticeBuilt 1960 · S/N 57483N9683XBates Roger · Palm Beach Gardens, FLBuilt 1962 · S/N 21057983N96840Brad Force One LLC · Terre Haute, INBuilt 1979 · S/N 18266872N96843Southside Air LLC · Bakersfield, CABuilt 1979 · S/N 18266874
Back to AD 79-10-14 R1