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.

N6901EBostik Industries LLC · Green Cove Springs, FLBuilt 1959 · S/N 56401N6901HRieser Steven E II · Baltimore, OHS/N 17265637N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301N6902ABasher Michael H · Morehead City, NCBuilt 1956 · S/N 29002N6902XPoules Alexander · Hope Valley, RIBuilt 1960 · S/N 17247802N6903AFisher Joe S · Smithville, MOBuilt 1956 · S/N 29003N6903GShipe Jacqueline M · Louisville, TNBuilt 1970 · S/N 15072403N6903SSchewe William · Greenville, ILS/N 15067603N6904MSommers William C · Temperance, MIBuilt 1975 · S/N 18263887N6904SKoller Rex E · Athens, ALS/N 15067604N6905HTang Flyer LLC · Wausau, WIBuilt 1975 · S/N 17265638N6905SSwanson David L · Rolling Meadows, ILBuilt 1967 · S/N 15067605N6905XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1960 · S/N 17556903N6906EArnold Gerald D · Albuquerque, NMBuilt 1959 · S/N 56406N6906XDucharme Lynn S · Polson, MTBuilt 1960 · S/N 17247806N6907GMaguire Dennis · Delaware, OHBuilt 1970 · S/N 15072407N6907XCamp Paul L · Fort Wayne, INBuilt 1960 · S/N 17247807N6908ACarreiro Alexander · Doral, FLBuilt 1956 · S/N 29008N6908FFrickel Thomas L · Bristow, NEBuilt 1966 · S/N 15063508N6908MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700672N6909Mcgrew Aaron · Bremen, GABuilt 1958 · S/N 57514N6909EWhite Dewayne · Yreka, CABuilt 1961 · S/N 56409N6909FCosgriff Kevin R · Midway, KYS/N 15063509N6909GStemper Peter L · Madison, SDBuilt 1970 · S/N 15072409N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309N690DMGabriel Louis R · Crestview, FLBuilt 1969 · S/N 18259626N690TSMartin Tony A · Kingwood, TXS/N 177RG0384N6910ACook Mike R · Rye, COBuilt 1956 · S/N 29010N6910EDakota Aircare Inc · Wagner, SDS/N 56410N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310N6910XRegistration Pending · Mcpherson, KSRegistration pendingS/N 17247810N6911ABryson John C III · Bath, NYBuilt 1956 · S/N 29011N6911EHannah Riley · Hillsville, VAS/N 56411N6911FOlson Richard S · Massena, NYBuilt 1966 · S/N 15063511N6911HHarbour Aviation LLC · Weatherford, TXBuilt 1975 · S/N 17265639N6911SHodges John Wesley · Chesapeake, VABuilt 1967 · S/N 15067611N6911XNorth Georgia Aviation Management Group LLC · Cumming, GABuilt 1960 · S/N 17247811N6912AKinsey Craig Russell · Sidney, TXBuilt 1956 · S/N 29012N6912G98x LLC · Caddo Mills, TXBuilt 1970 · S/N 15072412N6912XFahrne John E · Bradley, MIBuilt 1960 · S/N 17247812N6913EHampton Richard A · Seymour, INBuilt 1959 · S/N 56413N6913GAshland Jeffrey C · Spirit Lake, IABuilt 1970 · S/N 15072413N6913MFlesher John · Wadsworth, ILBuilt 1975 · S/N 18263889N6913XEllis Mark C · Rogers, ARS/N 17247813N6914EDodge Donald A · Dupuyer, MTBuilt 1959 · S/N 56414N6914FStephens Nicholas J · Santa Rosa, CABuilt 1966 · S/N 15063514N6914MChristilles Darrell Wayne · New Braunfels, TXS/N 18263890N6914XMagee Wayland S · Agency, MOBuilt 1960 · S/N 17247814N6915ACraig Linda I · East Freetown, MABuilt 1956 · S/N 29015N6915FTillison Glenda L · Cameron Park, CABuilt 1966 · S/N 15063515
Back to AD 79-10-14 R1