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.

N9665VAircraftsmen LLC · Heber City, UTS/N 17264445N9665XBarclay Richard W · Elbert, COBuilt 1962 · S/N 21057965N96665Sharp Darren · Greeley, COBuilt 1979 · S/N 18266799N96668Hollister Flying Club · Tulare, CAS/N 18266801N9666GDl Elk Outfitters Inc · Cascade, MTBuilt 1974 · S/N 18263423N9666HMorton Tamera L · Belpre, OHBuilt 1975 · S/N 17266301N9666VMedia Stew LLC · Carson City, NVBuilt 1974 · S/N 17264446N96673Seaton Bradley G · Rio Verde, AZBuilt 1979 · S/N 18266803N96679Jacobi Joseph L · Mexico, MOBuilt 1979 · S/N 18266807N9667ALight For Living Inc · Harvest, ALBuilt 1950 · S/N 15388N9667VWilliams Burla L · New Cumberland, WVBuilt 1974 · S/N 17264447N9667XBoschee Gary L · North Fort Myers, FLBuilt 1962 · S/N 21057967N96683Otter Wings Inc · Evansville, WIBuilt 1979 · S/N 18266808N9668TSevier Brady · Ronan, MTBuilt 1960 · S/N 57468N9668VMurphy David J · Humble, TXBuilt 1974 · S/N 17264448N9669ADella David Dan · Vacaville, CABuilt 1950 · S/N 15390N9669QAce Flight Center Inc · St Thomas, VIBuilt 1975 · S/N 17265753N9669XThc Aero LLC · Boise, IDBuilt 1986 · S/N 18268584N966ACWhiskey Charlie Aero LLC · Poway, CABuilt 2001 · S/N 172S8845N966AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12481N966CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281966N966LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12036N966STAbc Builders LLC · Merritt Island, FLBuilt 1966 · S/N 18256972N96704Skylens LLC · Hammond, LABuilt 1979 · S/N 18266814N96705Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276105N9670HAllen Max R · Jefferson, GABuilt 1975 · S/N 17266302N9670QSalad Days Aviation LLC · Fargo, NDBuilt 1975 · S/N 17265754N9670VNichols Timothy J · Dixon, CABuilt 1974 · S/N 17264450N96713Mountain Top LLC · Lafayette, LABuilt 1979 · S/N 18266818N96715Gomez Ben A · Cullman, ALBuilt 1979 · S/N 18266819N9671BJw-Hoff Rentals LLC · Mandan, NDS/N 172RG0958N9671VSkywarrior Flight Training LLC · Pensacola, FLBuilt 1974 · S/N 17264451N96720Nb Air LLC · Dover, DEBuilt 1979 · S/N 18266823N96725Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266825N9672AJohnstone Deborah L · Edmonds, WABuilt 1950 · S/N 15393N9672VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264452N9672XPallister John S · Battle Ground, WABuilt 1962 · S/N 21057972N96733Thompson Kyle · Babcock Ranch, FLBuilt 1979 · S/N 18266829N96734D & G Aviation LLC · Woodward, OKBuilt 1976 · S/N 21061213N96737Smith Flying Farms LLC · Leoti, KSBuilt 1979 · S/N 18266833N96739Euroaviation Inc Trustee · KematenBuilt 1979 · S/N 18266834N9673AGiesbrecht Shane R · Grand View, IDS/N 15394N9673VTaylor Charles E · Killdeer, NDBuilt 1974 · S/N 17264453N96742Parsons Lisa A · Shade Gap, PABuilt 1979 · S/N 18266837N96749Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18266840N9674AKubitschek William J · Mansfield, MOS/N 15395N9674GN1705r Inc · Cobb, CAS/N U20601874N96751Dsr Cherokee 180 LLC · Dallas, TXBuilt 1984 · S/N 17276110N9675BBlessum Jay · Minot, NDBuilt 1957 · S/N 32972N9675XKenai Gravel Products LLC · Galena, AKFirst renewal noticeBuilt 1962 · S/N 21057975
Back to AD 79-10-14 R1