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.

N7715AWallace Wayne P · Graham, WABuilt 1956 · S/N 32612N7715GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259415N7715KDutch Air LLC · Kalispell, MTBuilt 1976 · S/N 18052708N7715UFenton Dale R · New Bern, NCBuilt 1964 · S/N 17251715N7716GFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259416N7716UOpportune Entity LLC · Sanger, TXBuilt 1964 · S/N 17251716N77177Nazario Caleb R · Orlando, FLBuilt 1977 · S/N 177RG1118N7717AMcclelland Jacob D · Fairfield, CABuilt 1964 · S/N 15060886N7717GJohnson Eric C · Turtle Lake, NDBuilt 1970 · S/N 17259417N7717TGully Samuel Lee · Noxapater, MSBuilt 1960 · S/N 47317N7717UGreen Castle Aero Club Ltd · Oxford, IABuilt 1964 · S/N 17251717N77182Magro Daniel L Sr · Piperton, TNS/N 182-65921N77185Carter Danny · Baxley, GABuilt 1973 · S/N 18261744N7718EHeuser Timothy J · Cottage Grove, ORS/N 17518N7718FAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1966 · S/N 15063818N7718URenninger Dustin L · Mc Veytown, PAS/N 17251718N7719EOlson Ben A · Gig Harbor, WAS/N 17519N7719TRushton George Emery · Clinton, MIS/N 47319N771CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281781N771DCTlh Enterprises Inc · Corsicana, TXS/N 18504205N771EEBtr Inc · Chula Vista, CAS/N 18254542N771KKnutson Aviation Inc · Cedar Hill, TXBuilt 1977 · S/N 18052899N771KCAkin John · Highland, CABuilt 1975 · S/N 18264033N771PMaxq Composites LLC · Oxford, MEBuilt 1969 · S/N 337-1165N771SMGilbreath Tony C DBA · Olustee, OKBuilt 1967 · S/N 337-0614N771TMMid-South Aviation LLC · Caruthersville, MOBuilt 2011 · S/N 18282286N771XRanney Dorothy Gayle · Cordova, AKBuilt 1967 · S/N 185-1336N77206Venture Alaska LLC · Homer, AKBuilt 1977 · S/N U20603771N7720AKrueger Eric J · Olivehurst, CABuilt 1956 · S/N 32617N7720EAircraft Systems Group Inc · Odessa, FLBuilt 1959 · S/N 17520N7720GZulu Jets LLC · Boerne, TXBuilt 1970 · S/N 17259420N7720XJeter Thomas L · South Padre Island, TXBuilt 1960 · S/N 17248220N7721AAngel Steven · Fairbanks, AKBuilt 1956 · S/N 32618N7721GWurtsboro Airpark LLC · Wurtsboro, NYS/N 17259421N7721TBourdon Alain · West Springfield, MABuilt 1960 · S/N 47321N77222Davis Sam Alan · Wendell, NCBuilt 1973 · S/N 17262487N7722FSmall Tony D · Welch, OKBuilt 1972 · S/N 18261560N7722GKnaack Roland · Cumming, GABuilt 1970 · S/N 17259422N7722TPfc Aviation Repair Inc · Wallingford, CTS/N 47322N7722UBeebout Shawn C · Milroy, MNBuilt 1964 · S/N 17251722N7722XLeasure Everett D · Joliet, ILBuilt 1960 · S/N 17248222N7723ADoremus Scott M · Wolfeboro, NHBuilt 1956 · S/N 32620N7723FSchlueter Rodney E · Kansas City, MOBuilt 1966 · S/N 15063823N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357N7723UAdams David C · Westford, MABuilt 1964 · S/N 17251723N7724GWind Walker LLC · Tucson, AZBuilt 1970 · S/N 17259424N7724KGardner Thomas W · Lincoln, MEBuilt 1976 · S/N 18052711N7724XJohnson Randy G · Collinsville, OKBuilt 1960 · S/N 17248224N7725FToney Michael · Saint Peters, MOBuilt 1966 · S/N 15063825N7725UCvz-Vivace LLC · Fort Worth, TXBuilt 1964 · S/N 17251725
Back to AD 79-10-14 R1