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.

N2270PNorman Robert A · Zanesville, OHBuilt 1957 · S/N 23-880N2270UPrice Keyth E · Ossian, INBuilt 1964 · S/N 433N2271Eisele Elton L · Schaumburg, ILBuilt 1968 · S/N 227N22711Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-865N2271ESharmouj Raymond · St Croix, VIBuilt 1978 · S/N 17271215N2271PHorton Christian J · Melbourne Beach, FLBuilt 1957 · S/N 23-881N2271TLynch Lawrence Michael · Tempe, AZBuilt 1969 · S/N 357N2271UHockett James S · Chiloquin, ORBuilt 1964 · S/N 436N2272MGriff Air Ltd · Elk Grove, ILBuilt 1977 · S/N 28-7816269N2272USurplus Industrial Materials LLC · Centralia, WAS/N 437N2272YWilson Matthew C · Robinson, ILBuilt 1967 · S/N 17700072N2273FCascade Aviation LLC · Burlington, WABuilt 1969 · S/N 28-25431N2274PAvaero LLC · Worthington, OHBuilt 1973 · S/N 17261637N2274QMaines Barry K · Longview, TXS/N 28-7790390N22752Flying Tigers Flight School Ltd · Houston, TXBuilt 1974 · S/N 17264075N22754Gomez Abigail S · Carlsbad, CABuilt 1974 · S/N 17264076N22755Anderson Ronald L · Weatherford, TXBuilt 1990 · S/N 1111N22759Park Forest South Aviation Group · Mount Prospect, ILBuilt 1968 · S/N 15068501N2275SLoughran Gregory · Sierra Vista, AZBuilt 1999 · S/N 2619N22760Tuskegee Airmen National Historical Museum · Detroit, MIS/N 28-7425211N22763Horstick Thomas E · Garnett, KSS/N 28-7425213N2277DTaking Flight LLC · Saint Augustine, FLBuilt 1974 · S/N 28-7425225N2277URegistration Pending · Twin Falls, IDRegistration pendingS/N 442N2277VN2277v LLC · Mesa, AZBuilt 1975 · S/N 28-7525188N227FBAtlantic Flying Club Inc · Fernandina Beach, FLBuilt 1979 · S/N 17272654N227HPBritt Joseph A · North Augusta, SCBuilt 2008 · S/N 90760N227JBMorehouse Flying Service Inc · Mer Rouge, LABuilt 1977 · S/N 18-7709114N227JCCrabtree John · Evansville, INBuilt 1996 · S/N JC-01N227MDAfd Solutions Inc · Dekalb, ILBuilt 1999 · S/N MD001N227MJRausch Patricia E · Montgomery, TXBuilt 2003 · S/N 887N227RVSoule Stephen J · Waterbury Center, VTBuilt 2001 · S/N 24293N227SFSager Charles K · Hedgesville, WVBuilt 2000 · S/N 437-2000N227THPristatskly Roman · Ivyland, PAS/N 227N2281QFreeman Michael J · Chillicothe, OHBuilt 1977 · S/N 28-7716096N2284DKellner Aaron · Bloomfield, CTBuilt 1995 · S/N 1N2284PChickasha Wings Inc · Chickasha, OKBuilt 1957 · S/N 23-895N2284UAttitude Toys LLC · Wilmington, DES/N 454N2284YBorn Daniel P · Lawrence, KSBuilt 1967 · S/N 17700084N2285YKrid Cardinal LLC · Centerville, INBuilt 1967 · S/N 17700085N2286MRegan Herbert George · Gowen, MIBuilt 1977 · S/N 28-7816271N2287CKounovsky Jerry F · Tucson, AZBuilt 1967 · S/N 272N2287P250 Flyers LLC · Middletown, DEBuilt 1957 · S/N 23-898N2288PChisum Robert · Lorenzo, TXS/N 23-899N2288ULay Jerry K · Minonk, ILBuilt 1966 · S/N 459N2288ZMaxwell Robert H Jr · Quincy, FLS/N 28-2196N2289ABauer Melchior E · Vallejo, CAS/N 22-677N2289MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816274N2289UEastern Stearman Inc Trustee · Leesburg, VABuilt 1966 · S/N 460N228ARHurricane Creek Flying Club LLC · Walla Walla, WABuilt 1979 · S/N 17273580N228CJSplashin LLC · White Lake, MIBuilt 1977 · S/N 17269610
Back to AD 79-10-03 R2