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.

N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529N3391RValiair Lc Trustee · Casper, WYBuilt 1969 · S/N 28-5668N3391XDunham Seth Aaron · Acampo, CABuilt 1966 · S/N 3386N3391ZThompson Michael M · Soldotna, AKBuilt 1960 · S/N 18-7276N3392REllsworth Steven C · Muscatine, IABuilt 1969 · S/N 28-5669N3393RBay Richard G · Sparks, NVBuilt 1969 · S/N 28-5672N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693N3393ZWilliams Shane · Union, ORS/N 18-7279N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694N3394ZNord Margie N Trustee · Cantwell, AKBuilt 1960 · S/N 18-7281N3396QRomanair Wdr Inc · Winder, GABuilt 1977 · S/N 28-7790455N3396XS R Gilliam Construction Inc · Carthage, NCS/N 3388N3396ZPineland Holdings LLC · Gibsland, LABuilt 1960 · S/N 18-7285N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697N3398R3y3 Piper Group LLC · Saint Charles, IABuilt 1969 · S/N 28-5671N339AMills Scott I · Littleton, COBuilt 2005 · S/N 90493N339DLFriedrich Robin K · Houston, TXS/N 90206N339EEvans James W Jr · Wake, VABuilt 1985 · S/N 759N339ECBlackmore Marc A · Hilltop Lakes, TXBuilt 1977 · S/N 20017N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784N33AWWeigle Alan B · Seward, NEBuilt 2001 · S/N 489N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182N33ELAdvancing Blade LLC · Glenwood, MNBuilt 1992 · S/N 20770N33ERCrump Edward J · Boonton, NJBuilt 1978 · S/N AA5B0884N33EYYoung Robert E · Princeton, NCBuilt 2016 · S/N 11354N33FKMotis Joseph D · Huntington Beach, CABuilt 1970 · S/N 28-5763N33FUZeiset Karl D · Salmon, IDBuilt 1979 · S/N 241N33GLJohnston Jeremy A · Cedar Springs, MIBuilt 1983 · S/N 532N33HSN33hs LLC · Tallahassee, FLS/N 1HSN33JSaunders Dwayne E · Cary, NCBuilt 1973 · S/N JF-1N33JCMurphree Matthew · San Marcos, TXBuilt 1977 · S/N 28-7890144N33JJFincor Inc · Miami Beach, FLBuilt 1972 · S/N AA5-0061N33JXProuty Timothy V Trustee · North Providence, RIBuilt 1977 · S/N AA5B0585N33KJPlane Fun Inc · Bow, WABuilt 1998 · S/N 23035N33LYBobo Robert A · Pullman, WABuilt 2001 · S/N 001N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N33PZRygiel Jerome A · Saint Cloud, FLBuilt 1975 · S/N 28-7615040N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948N33SPCray Jaeger · Hilton Head, SCS/N 28-366N33VLPalmer Thomas W · Boulder City, NVBuilt 1994 · S/N 11043
Back to AD 79-10-03 R2