OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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-03-R2')
    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-03-R2')
  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.

N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023N3481TEstes Kenneth · Portland, ORS/N 17700781N3481XN3481x LLC · Reno, NVBuilt 1966 · S/N 3421N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029N3482THaskell Thomas Edward · Georgetown, TXBuilt 1968 · S/N 17700782N3482XCollins Dallas · Columbia, SCBuilt 1966 · S/N 3422N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033N3483TCalhoun Edward J · Whitney, NEBuilt 1968 · S/N 17700783N34845Ccf Ventures Inc · Bangor, MES/N 17702039N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041N3484MNiner One Aviation LLC · Hillsboro, ORBuilt 1947 · S/N 12-2080N3484TCairo Jane LLC · Ponca City, OKBuilt 1968 · S/N 17700784N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049N3485ZVarco John M · Palmer, AKBuilt 1960 · S/N 18-7317N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064N34888Double J3 Aviation LLC · West Palm Beach, FLS/N 17702066N3488ZBastian Richard L · Burns, WYBuilt 1960 · S/N 18-7325N34894Whitney Ron · Indianapolis, INBuilt 1974 · S/N 17702070N34896Kidron Flying Club Pll · Wooster, OHBuilt 1974 · S/N 17702071N34897Loscheider Brian P · Cologne, MNBuilt 1974 · S/N 17702072N3489KGfh LLC · Zillah, WABuilt 1967 · S/N 28-23582N3489TBlue Skies Aviation LLC · Belfast, MEBuilt 1968 · S/N 17700789N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564N348JWHupp Patrick · Gladstone, MOBuilt 2001 · S/N 01JWN348KEEllwood Luke D · Springboro, OHBuilt 1998 · S/N 001N348MAWilson Ralph W Trustee · Mentor, OHBuilt 2002 · S/N 1337-2002N348MBClay David L · Bryceville, FLS/N 1662N348RVBayani Amir · Roswell, GABuilt 2002 · S/N 81189N348SAPutman James R Jr · Kernersville, NCBuilt 1974 · S/N 17702065N348STDream Aircraft Inc · Zeeland, MIS/N 529N34900Payne Richard L · Flint Hill, VABuilt 1974 · S/N 17702074
Back to AD 79-10-03 R2