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.

N642ABauer Thomas M · Elizabethtown, KYBuilt 1966 · S/N 18257036N642AWHobart Aviation Inc · Akron, OHBuilt 1974 · S/N 17264124N642KMNick Heir LLC · Lexington, KYFirst renewal noticeBuilt 2005 · S/N 172S10053N642MALittle Bird 150 LLC · Parsons, TNS/N 15061292N642NDPelican Flight Training LLC · San Carlos, CABuilt 2015 · S/N 172S11616N642RSRomeo Sierra Aviation LLC · Sparks, NVBuilt 1980 · S/N 172RG0472N642SPBlue Sky Aviation Association Inc · Readington, NJBuilt 1998 · S/N 172S8050N642THFairmont State University · Fairmont, WVBuilt 2021 · S/N 172S12642N642WRN642wr LLC · Henderson, NVS/N 182-65115N64301B&R Aircraft LLC · Wadsworth, OHBuilt 1975 · S/N 17265152N64302Lanehart Zachary · Keo, ARBuilt 1975 · S/N 17265153N64303Acey Services LLC · Cumming, GABuilt 1975 · S/N 17265154N64305Skyhaven Flying Club Inc · Dover, NHBuilt 1975 · S/N 17265155N64307Flywyo LLC · Kalispell, MTBuilt 1975 · S/N 17265157N64308Rein Robert G · Seattle, WABuilt 1975 · S/N 17265158N64309Sveta Kadirova · Louisville, KYFirst renewal noticeS/N 17265159N6430ATulsa Technology Center School District No 18 · Tulsa, OKBuilt 1956 · S/N 33230N6430XLegner Leasing LLC · Las Vegas, NVS/N 18050930N64313Aerial Scouting Solutions LLC · Sioux Center, IABuilt 1975 · S/N 17265163N64314Registration Pending · New Bern, NCRegistration pendingBuilt 1975 · S/N 17265164N64317Spernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1975 · S/N 17265165N6431BStecconi Ferraro Denise M · Seattle, WABuilt 1957 · S/N 29631N6431EGroup 172 LLC · Tucson, AZBuilt 1959 · S/N 46531N6431GSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 15071931N6431NMorton Craig Allister · Toluca Lake, CABuilt 1978 · S/N 21063007N6431THarrigan Bernard J · Fontana, WIBuilt 1960 · S/N 17831N64325Varney Aviation LLC · Bangor, MEBuilt 1982 · S/N 17275545N64328Compass Aviation Inc · Shelby, NCBuilt 1975 · S/N 17265169N64329Bvs Aviation LLC · Burns, ORS/N 17265170N6432BSmith Robert E Jr · Shell Knob, MOBuilt 1957 · S/N 29632N6432VShortridge Randall R · Mesa, AZBuilt 1980 · S/N 172RG0693N64330Cornelius Beverly B · Merrill, WIBuilt 1975 · S/N 17265171N6433232 Leasing LLC · Englewood, COBuilt 1975 · S/N 17265172N64333Sawtooth Aviation LLC · Hovland, MNBuilt 1975 · S/N 17265173N64334Vrionides Polis G · Collinsville, CTBuilt 1975 · S/N 17265174N64335Cox Dennis J · Beach City, TXBuilt 1975 · S/N 17265175N64336Moore Joseph C · Farmers Branch, TXBuilt 1975 · S/N 17265176N64337Clearwater Airco LLC · Anchorage, AKBuilt 1977 · S/N 18052891N6433AWagar Dennis Murphy · Marion, MTS/N 33233N6433EMorgan Peter F · Parma, IDBuilt 1959 · S/N 46533N6433SDandrea Robert · Portage, PABuilt 1967 · S/N 15067233N6433XRand Carl · Durango, COBuilt 1980 · S/N U20605882N64340Spartan Aviation Services LLC · Parkland, FLBuilt 1975 · S/N 17265178N64344Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1982 · S/N 17275548N64345Sundstrom Jeffery V · Fresno, CABuilt 1975 · S/N 17265182N6434NDecker Rufus G III · Arlington, VABuilt 1978 · S/N 21063010N6434RCutlass Aviation LLC · Auburn, ALBuilt 1985 · S/N 21064926N6434THoran Jack F · De Berry, TXBuilt 1960 · S/N 17834N64350Byrne David D · Essex Fells, NJBuilt 1975 · S/N 17265185N64355N64355 LLC · Boulder, COS/N 17265187
Back to AD 79-10-14 R1