OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N5926DToste Greg · Newcastle, CABuilt 1956 · S/N 22-4589N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143N5926UIron Flyer Of Cuzamil LLC · Lewes, DES/N 28-26739N5926WLeonard Jeffrey A · Bakersfield, CABuilt 1966 · S/N 28-3311N5927PSchlup John R · Booneville, ARBuilt 1959 · S/N 24-1015N5927WKochling Christopher · Houston, TXBuilt 1966 · S/N 28-3331N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928WRegistered aircraftN-number assigned, not yet registeredS/N 28-3367N5929WEdwards Allan · Leesburg, VABuilt 1966 · S/N 28-3368N592DJFandango Ranch Operating Co Inc · Anacortes, WAS/N 592N592FLGrey Rose Air LLC · Edenton, NCBuilt 1971 · S/N 28-7125455N592RSProbst Danny R · Nokomis, ILBuilt 2003 · S/N 90400N592ZHorton Michael D · Vernal, UTBuilt 1994 · S/N 1523N5930USplendid Air Leasing LLC · Dover, DEBuilt 1970 · S/N 28-26726N5930WGraham James C Co-Trustee · Bellville, OHBuilt 1966 · S/N 28-3376N5931DStone Robert K · Piney Flats, TNBuilt 1956 · S/N 22-4594N5931UJ And H Aircraft Leasing Inc · Palmyra, PABuilt 1970 · S/N 28-26814N5932Autry Marbella A · Montrose, COBuilt 1973 · S/N 022N5932URegistration Pending · Bulverde, TXRegistration pendingBuilt 1971 · S/N 28-7125143N5932WSchaaf Rodney B · Bowman, NDBuilt 1966 · S/N 28-3383N5933DHoward Trent R · Mandan, NDS/N 22-4596N5933QDonaldson Lucas P · Owyhee, NVS/N 3177N5934DBalsley Matthew G · Rowlett, TXS/N 22-4597N5934VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1978 · S/N 28-7816603N5934WDear Stephen R · Pioneer, CABuilt 1966 · S/N 28-3408N5935PDaniel Hardy L Jr · Derby, KSBuilt 1959 · S/N 24-1025N5936DSchreiber Faith E · Valparaiso, INBuilt 1956 · S/N 22-4599N5936QEllis Robert L · Columbus, OHBuilt 1965 · S/N 3180N5937GD'Arge Ranyon Wc · Wilson, WYBuilt 1969 · S/N 15071437N5937PTindall Michael C · Granite City, ILBuilt 1959 · S/N 24-1027N5937QPospicil John A · Huntsville, ALBuilt 1965 · S/N 3181N5937WMikesell Lloyd L · Kokomo, INBuilt 1966 · S/N 28-3437N5938ULame Duck Aviation LLC · Leesburg, INBuilt 1970 · S/N 28-26829N5938WDewald Joseph L · Fort Wayne, INBuilt 1966 · S/N 28-3452N5939WPhillips Morris · Decatur, GABuilt 1966 · S/N 28-3498N593ASwift Harvey G · Clinton, ARBuilt 1968 · S/N S-512N593FLEmpire Aviators LLC · Long Island City, NYBuilt 1971 · S/N 28-7125456N593SPFull Rudder Flyers LLC · Mesa, AZBuilt 1966 · S/N 28-22459N593STN593st LLC · Bangor, MEBuilt 1985 · S/N 17276454N5940DRunnin Rabbit LLC · Kalispell, MTBuilt 1956 · S/N 22-4603N5940PSilver Arrows LLC · Beaverton, ORBuilt 1959 · S/N 24-1030N5940UStrong Colin · Portland, ORFirst renewal noticeBuilt 1970 · S/N 28-26830N5941WCunningham James R · Collierville, TNBuilt 1966 · S/N 28-3518N5942DFour For Flying Inc · Holyoke, COBuilt 1956 · S/N 22-4605N5943EPlane Zane LLC · Stuart, FLBuilt 1978 · S/N 17271969N5943QFreeborn Andrew B · North Las Vegas, NVBuilt 1965 · S/N 3187N5943URoth Larry · Marion, IABuilt 1970 · S/N 28-26849N5943WSallee Steven A · St George, UTS/N 28-3482N5944DBradley Dennis Michael · Myrtle Beach, SCBuilt 1956 · S/N 22-4607N5944WFerguson Robert C · Cornelia, GAS/N 28-3529
Back to AD 79-10-03 R2