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.

N6943BAndrews Joshua T · Lakeview, ORBuilt 1956 · S/N 22-4223N6943NPhoenix Aviation Holdings LLC · Mesa, AZBuilt 1968 · S/N 680192N6944CUpdraft Leasing LLC · Tea, SDBuilt 1978 · S/N 28-7816442N6944EHinds Archie L · Claremore, OKBuilt 1978 · S/N 17272076N6944NYates Gary Douglas · Rose Hill, KSS/N 680153N6945NEveland Benjamin E · Henderson, NVBuilt 1968 · S/N 680193N6945PBerg Alvin L · Overgaard, AZBuilt 1960 · S/N 24-2080N6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledBuilt 1953 · S/N 25522N6947BB&R Aerial Crop Care Inc · Connell, WABuilt 1957 · S/N 22-4227N6947NFlyfaraway Partners LLC · Sparta, NJBuilt 1968 · S/N 680194N6948NPeck Jeff · Denton, TXS/N 680195N6948WCraig Joshua G · Bonaire, GABuilt 1965 · S/N 28-21134N6949BPool Gene E · Anchorage, AKBuilt 1956 · S/N 22-4229N6949NBanos Peter T · Coalinga, CABuilt 1968 · S/N 680155N6949PDepew Kevin I · Everett, WABuilt 1960 · S/N 24-2084N6949WSa Fliers LLC · Venice, FLBuilt 1965 · S/N 28-21138N694ABGoldpick Dirtworx LLC · Wasilla, AKBuilt 1957 · S/N 22-5347N694ARWilliams Robert R · Vernonia, ORBuilt 1947 · S/N 12-1507N694BASlawko Paul A · Elverson, PABuilt 1990 · S/N 694USN694DCSweet Dixie Aviation LLC · Reddick, FLBuilt 2004 · S/N 3573N694JSHowell Renny P · Whitehouse, TXS/N 23-1571N694PBlack Robert · New Market, ALS/N 2802N694PSSteger Paul M · Locust Grove, GAS/N 23-1732N694RMTavel Charles · Cave Creek, AZBuilt 2005 · S/N 2843607N694VHall Davis Warren · Mobile, ALBuilt 2003 · S/N 80694N6950BLudwig Henry H · Fort Worth, TXBuilt 1956 · S/N 22-4238N6950DFaught Jeffrey R · Bismarck, NDS/N 22-4879N6950PRegistered aircraftBuilt 1960 · S/N 24-2085N6950WEalp LLC · Evansville, INBuilt 1965 · S/N 28-21140N6952BWesley Jerry A · Moorland, IAS/N 22-4232N6952WBeaver Milton H II · Palmer, AKBuilt 1965 · S/N 28-21143N6953DLambert Hubert D Sr · Lincolnton, NCBuilt 1957 · S/N 22-4882N6953WScotting David R · Pipestone, MNBuilt 1965 · S/N 28-21144N6954PJcav8 LLC · Cartersville, GABuilt 1960 · S/N 24-2090N6955DGlover Thomas B · Marana, AZFirst renewal noticeBuilt 1957 · S/N 22-4884N6956BBushplane Lab LLC · Wilderville, ORBuilt 1956 · S/N 22-4237PN6956JJuliet Sky LLC · Sioux City, IABuilt 1976 · S/N 28-7690439N6956VAbney Timothy R · Crossett, ARBuilt 1975 · S/N 20-1189N6957BVaughn James R · Winchester, KYBuilt 1956 · S/N 22-4239N6957PHoran Edward · Wexford, PABuilt 1960 · S/N 24-2095N6957VKnoke Keith W · Litchfield Park, AZBuilt 1976 · S/N 20-1190N6958HJewell Aviation Inc · Kennett, MOBuilt 1975 · S/N 17265663N6958JAkin Enterprises Inc · Greensboro, GABuilt 1976 · S/N 28-7690441N6958UVauclin Brady P · Shreveport, LAS/N 2709N6958VSale Reported · Austin, TXSale reportedBuilt 1976 · S/N 20-1191N6958WPeck Michael S · Las Vegas, NVBuilt 1965 · S/N 28-21150N695ACHodgson Daniel J · Anchorage, AKBuilt 1998 · S/N 394-98N695FLPugh Daniel J · Omaha, NEBuilt 1971 · S/N 28-7125634N6960HZiller Wayne Jr · Fairbury, ILBuilt 1975 · S/N 17265664N6960UWayne Brett M · Saint George, UTBuilt 1964 · S/N 2711
Back to AD 79-10-03 R2