OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N88059Tidewater Soaring Society · Windsor, VAS/N 72-74N8805CSandifer Steve R · Barnwell, SCBuilt 1953 · S/N 22-1419N88065Obx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 460-74N88066Nightingale Patrick R · Lakewood, CABuilt 1974 · S/N 1037-74N8806JLytle Hugh R · Senoia, GABuilt 1965 · S/N 28-2756N8806NHorne Terry A · Carefree, AZBuilt 1969 · S/N 28-25652N8807Potter David · Huntley, ILBuilt 1973 · S/N 473-73N8807DGorski Tim B · Larsen, WIBuilt 1958 · S/N 22-5975N8807JNorris Dana G III · Zanesville, OHS/N 28-2757N8807NTruax James D · Roanoke, INBuilt 1969 · S/N 28-25653N88081Butler Julie L · Los Osos, CABuilt 1974 · S/N 718-74N88083N3542w Inc · Wilmington, DEBuilt 1974 · S/N 719-74N88085Poulson Daniel J · Anchorage, AKBuilt 1974 · S/N 722-74N8808DDwight Thomas W · Castalia, OHBuilt 1958 · S/N 22-5977N8808JCoulliette Brian K · Jacksonville, FLBuilt 1965 · S/N 28-2758N88092Verhulst Charles · Reva, SDBuilt 1974 · S/N 723-74N880CBJ-Airco LLC · Nashville, TNBuilt 1973 · S/N 17262582N880FTFlorida Institute Of Technology · Melbourne, FLBuilt 2000 · S/N 4496033N880HCBadger Heli Corp · Wilmington, DEBuilt 1989 · S/N 1208N8810DNorman Timothy J · Tofte, MNBuilt 1958 · S/N 22-5979N8810NShawl Robert M · Woodlake, CABuilt 1969 · S/N 28-25657N88110Lovas Thomas A · Anchorage, AKBuilt 1974 · S/N 725-74N88118Richard Thomas W · Greenville, MSBuilt 1974 · S/N 726-74N88119Aysta Nathan P · Hermantown, MNBuilt 1974 · S/N 606-74N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718N8812DSowders Darwin G · Robinson, TXBuilt 1958 · S/N 22-5981N88130Harper Clayton E · Seabrook, TXBuilt 1974 · S/N 727-74N8813NLangton Shane A · Boise, IDBuilt 1969 · S/N 28-25660N88144Hitchens Steven · Conesville, OHS/N 79-74N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268N8814JCarey H Dwain · Cheyenne, WYBuilt 1965 · S/N 28-2766N8814NMarshall Lance A · Portland, ORBuilt 1969 · S/N 28-25661N88156Wilcox Aerial Applications Inc · Tilden, NEBuilt 1974 · S/N 730-74N8815NJenkins Roger Clayton II · Plain Dealing, LABuilt 1969 · S/N 28-25663N88161Jordan Jay S · Wasilla, AKBuilt 1974 · S/N 84-74N88165Becker Aaron S · Santa Cruz, CABuilt 1974 · S/N 731-74N8816JHuff Roger A · Johnstown, OHBuilt 1965 · S/N 28-2770N8817CSharon Ricky E · Roberta, GABuilt 1976 · S/N 28-7625132N8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1965 · S/N 28-2771N88181Oglesby Holdings LLC · Henrico, VABuilt 1974 · S/N 732-74N88189Ocean Aerial Ads Inc · Ocean City, MDS/N 89-74N88194Registered aircraftBuilt 1974 · S/N 91-74N881CDWestern Pilot Service Inc · Phoenix, AZBuilt 1958 · S/N TD-95N881JBHammer Roger W · Seattle, WAS/N 1289N881RDOrchard Richard W · Sagle, IDBuilt 1981 · S/N 18-8109047N881RWWilliams Summit LLC · Salmon, IDBuilt 1957 · S/N 18-6627N881TAMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3023N881WABlahut Robert John · Prosser, WABuilt 1968 · S/N 17257390N88200Auer William E · Saint Petersburg, FLS/N 736-74N88202Moore David J · Beechgrove, TNBuilt 1974 · S/N 737-74
Back to AD 79-10-03 R2