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.

N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N351GSKukowski Matthew P · Wheatland, WYBuilt 2000 · S/N 80713N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350N3521PJet Jam LLC · Layton, UTBuilt 1955 · S/N 22-3275N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272N35225Nguyen Ricky L · Honolulu, HIS/N 17702275N3522EKilgore William B · Eureka, CAS/N 17271572N3522KAsap Realty LLC · Stroud, OKS/N 28-23608N3522PBurling Daniel J DBA · Warsaw, NYBuilt 1955 · S/N 22-3276N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283N3523MMichigan Seaplane LLC · White Lake, MIBuilt 1947 · S/N 12-2369N3523PAdair Lawrence L Jr · Fountain Run, KYBuilt 1955 · S/N 22-3277N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289N3524PRichard Waldren LLC · Newberg, ORBuilt 1955 · S/N 22-3279N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462N3524ZRehmel Robert S · Liberty, INBuilt 1960 · S/N 22-7427N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293N3525ZCollier Ronald O Trustee · Seymour, TNBuilt 1960 · S/N 22-7428N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297N3526KCooke Canyon C · Marana, AZBuilt 1967 · S/N 28-23606N3526ZSwett John P · Zebulon, NCBuilt 1960 · S/N 22-7429N3527Link James L · Raleigh, NCBuilt 1971 · S/N ELC-1N35273Weltmer Aaron Reece · Rocklin, CABuilt 1975 · S/N 17702303N35278Sparks Tommy R · Palestine, ILBuilt 1975 · S/N 17702305N35281Freebird Wings LLC · Creswell, ORBuilt 1975 · S/N 17702306N35284Flying Redbirds LLC · Wentzville, MOBuilt 1975 · S/N 17702307N35287White James E · Eminence, KYBuilt 1975 · S/N 17702308N35288Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 5-605N3528PSalerno Joseph C Jr · Gettysburg, PABuilt 1955 · S/N 22-3283N352964 Point Transportation LLC · Excelsior Springs, MOS/N 17702312N3529KEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 28-23544N352AMWarren John L · Homer, AKBuilt 2003 · S/N 2252N352GAura LLC · Zeeland, MIS/N SKF97-1N352MAKilo Tango Aviation LLC · Watford City, NDBuilt 2000 · S/N 2107N352VAVictory Aviation Club Inc · Hamilton, OHBuilt 1976 · S/N 28-7690224N35302William Benjamin LLC · Orono, MNS/N 17256701
Back to AD 79-10-03 R2