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.

N321PKYaqunda Yousif N · Fallbrook, CABuilt 1994 · S/N PK-1N321RVRegistration Pending · Norton Shores, MIRegistration pendingBuilt 1998 · S/N 20372N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533N321VTWinick Scott · Jay, VTBuilt 1973 · S/N 507N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036N32204Flying Country Club Inc · Coal Valley, ILBuilt 1974 · S/N 28-7515094N32206Williams Jonathan · Meadow, TXBuilt 1974 · S/N 28-7515097N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037N32223Boehm William Dean · Baldwin, ILS/N 28-7515101N32228Segalla Susan B Trustee · Venice, FLBuilt 1974 · S/N 28-7505040N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163N3223PPrestige Tech Consulting Inc · Carrollton, TXS/N 1181N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541N32245Johnson Donald D · Scottsdale, AZBuilt 1974 · S/N 28-7515102N3224ZBagley Sherell G · Suwanee, GABuilt 1959 · S/N 22-7168N32251Kful Flyers Foudation Inc · Fullerton, CAS/N 28-7515104N32255Registered aircraftBuilt 1974 · S/N 28-7505041N32256Hasek Christopher A · Plano, TXBuilt 1974 · S/N 28-7505042N32258Wing Rentals LLC · Phoenix, AZBuilt 1974 · S/N 28-7505043N32265Norsesian Brandon · Valrico, FLBuilt 1974 · S/N 28-7525040N32267Top Flight Aviation LLC · Reedsburg, WIBuilt 1974 · S/N 28-7515105N32269Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7515106N3226NDeuel Justin R · Mankato, MNS/N 243N32271Tylka Edward · Lockport, ILBuilt 1974 · S/N 28-7505044N32274Simaan Daniel · Fontana, CABuilt 1974 · S/N 28-7525042N32276Price Company · Spokane, WABuilt 1974 · S/N 28-7515109N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475N3227MParker Shon T · Wasilla, AKBuilt 1947 · S/N 12-2108N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114N32288Habzansky Michael E · Greens Fork, INBuilt 1974 · S/N 287515112N32291Active Pilot Inc · Van Nuys, CABuilt 1974 · S/N 28-7515114N32292Mdr Rental Corp · Ann Arbor, MIBuilt 1974 · S/N 28-7515115N32293Stone James B · Springfield, VABuilt 1974 · S/N 28-7505046N32296Fly South Aviation LLC · Charlotte, NCBuilt 1974 · S/N 28-7525046N32299Lundahl Kristina N · Windsor, COBuilt 1974 · S/N 28-7515116N322ATAbkadirov Tagir · Tampa, FLS/N 1524N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545N322DRMcgrath James T · Campbell, CABuilt 2005 · S/N 81291N322DWAutry Michael D · Metuchen, NJBuilt 2015 · S/N 11384N322GEPierce Michael W · Leitchfield, KYS/N 0934N322MLAshcraft Aviation LLC · Bay City, TXS/N 3572N322SHelfrick Edward W Jr · Elysburg, PABuilt 1995 · S/N 2005N322ZLafaille David A · Simi Valley, CABuilt 1991 · S/N WP001N32300Primary Flight Control LLC · Fleming Island, FLBuilt 1974 · S/N 28-7515118N32306Legacy Pilot Training LLC · Annandale, MNS/N 28-7515120
Back to AD 79-10-03 R2