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.

N66425Biornstad John A · Big Lake, AKBuilt 1974 · S/N 15076039N6642ATundra Aviation Inc · Casselton, NDS/N 28742N6642FSomerset Flying Club · Basking Ridge, NJBuilt 1966 · S/N 15063242N6642GBurgmeier Peter W · North Vernon, INBuilt 1970 · S/N 15072142N6642SSellers Douglas D · Webster, NYBuilt 1967 · S/N 15067442N66431Neron II LLC · New Smyrna Beach, FLS/N 17275989N66437Fluno John I · San Anselmo, CAS/N 15076049N66439Mancini James N · Baltimore, MDBuilt 1974 · S/N 15076051N6643AMoore Michael J · Monroe, UTBuilt 1956 · S/N 28743N6643FAyresouth Aviation Inc · Lithia Springs, GABuilt 1966 · S/N 15063243N6643GStokes Patricia A · Nenana, AKFirst renewal noticeBuilt 1970 · S/N 15072143N66440Tenenboym Dennis Alexander · Pinellas Park, FLBuilt 1974 · S/N 15076052N66449Lindvig Thomas H · Williston, NDBuilt 1978 · S/N 18052944N6644GLive2flyfl Inc · Wilmington, DEBuilt 1970 · S/N 15072144N6644MSierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17260503N6644TGreenfield Amanda J · Palo, IABuilt 1960 · S/N 15059044N6644XCamous Daniel E · Miami, FLS/N 21057644N66452Bedard Michael J Trustee · Madison, ALBuilt 1974 · S/N 15076059N66453Beaudry Phillip H · Newport, VTBuilt 1974 · S/N 15076060N66455Soendergaard Carsten · Aguila, AZBuilt 1974 · S/N 15076061N66459Amelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 15076063N6645TMcelroy James S Jr · Goddard, KSBuilt 1960 · S/N 15059045N6645XHarrison Joshua C Trustee · Huntington Beach, CABuilt 1960 · S/N 21057645N66463Sikkema Romke P · Sebring, FLBuilt 1974 · S/N 15076065N66467Joe Dory Aviation LLC · Star, IDS/N 15076068N66469Pirtle Sandra Rinehart · Winnsboro, TXBuilt 1974 · S/N 15076070N6646ERegistration Pending · Elbert, CORegistration pendingBuilt 1959 · S/N 56146N6646GJenkinson Jeffery J · Montgomery, TXS/N 15072146N6646HIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1975 · S/N 17265523N6646TGillespie Justin M · Greensboro, NCS/N 15059046N66471Nelson Travis E · Richland, MTBuilt 1978 · S/N 18052945N66472Bgmaviate LLC · Fairfax, VABuilt 1974 · S/N 15076072N66478Mason John M · Gilbert, AZBuilt 1974 · S/N 15076074N66479Gardner John F · Lyons, NYFirst renewal noticeS/N 15076075N6648EEverest Builders LLC · Cheyenne, WYS/N 56148N66494Graham Luke R · Rushville, NEBuilt 1974 · S/N 15076081N6649AShaw Frank Edward · Chestertown, NYBuilt 1956 · S/N 28749N664AKWarren John · Homer, AKBuilt 1975 · S/N 17702148N664CAChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10135N664CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283357N664EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12549N664PBThomas Anthony Robert Jr · Frederick, MDBuilt 1998 · S/N 18280156N66501Sanders Robert M · Youngsville, NCBuilt 1974 · S/N 15076084N66502Dewey Holdings LLC · Florence, ALBuilt 1974 · S/N 15076085N66506Scott John J · Arcadia, FLBuilt 1974 · S/N 15076086N66507Gozdowski Matthew D · Sylvania, OHS/N 15076087N6650TAlumbaugh Bynum E · Jacksonville, FLBuilt 1960 · S/N 15059050N6650XMccloskey Brett E · Bexley, OHBuilt 1960 · S/N 21057650N66511Rawaero LLC · Warsaw, MOS/N 15076091N66516Mangon Aircraft Inc · Petaluma, CABuilt 1974 · S/N 15076094
Back to AD 79-10-14 R1