OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024N6492RFagerhaug Jeffrey · Orangevale, CABuilt 1966 · S/N 28-21684N6493RReifschneider Jay S · Patterson, CABuilt 1966 · S/N 28-21685N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657N6494RTurner Manley W Jr · Fredericksburg, VABuilt 1966 · S/N 28-21686N6495JStp Flight LLC · Saint Paul, MNBuilt 1968 · S/N 28-4926N6495UOtto David L · Lacey, WABuilt 1962 · S/N 2242N6495WScheibinger Alois E · Oshkosh, WIBuilt 1964 · S/N 28-20571N64962Wingsleasing LLC · Wichita, KSBuilt 1982 · S/N 17275659N64964Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275660N64966Hill Mark T · Gloucester, VABuilt 1982 · S/N 17275661N6496JBudke Kris J · Osceola, WIBuilt 1968 · S/N 28-4928N6496UWeaver Jimmie G · Winston Salem, NCS/N 2243N6497UPointer James E · Cumming, GAS/N 2244N6498FWisener Randall G · Addison, ALBuilt 1979 · S/N 17273232N6498JKvistad Jerome L · Coon Rapids, MNBuilt 1968 · S/N 28-4930N6499RGoodroe Zachary A · Santa Rosa Beach, FLBuilt 1966 · S/N 28-21692N6499USolley Richard T · Mott, NDBuilt 1962 · S/N 2246N6499WMarston Benjamin E · Seale, ALBuilt 1965 · S/N 28-20576N649GCAviation Paradise LLC · Homestead, FLBuilt 1979 · S/N 17273413N649MBThompson Brian P · Lebanon, TNBuilt 2003 · S/N 23872N649SAHelm Craig Anthony · Graham, TXBuilt 2006 · S/N S-0011N649TGGrove Todd M · Lake Stevens, WABuilt 2004 · S/N 21048N64AKKenley Fredrick · Palmer, AKBuilt 1976 · S/N 192-76N64CASwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 17275269N64CWHolmsley Peery · Sheffield, TXBuilt 1946 · S/N 12-903N64DKLevy Michael T · El Prado, NMBuilt 1991 · S/N 20009N64DTSharp Travis · Anchorage, AKBuilt 1975 · S/N 18-7509088N64EFHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17262871N64ELPridemore Michael R · Newport, MIBuilt 1969 · S/N M-1183N64FAFunnell Augustus H · Lake Oswego, ORS/N 24539N64FVStepec Edward J · Oregon City, ORBuilt 2004 · S/N 60114N64GHDivan Michael P · Bradbury, CABuilt 2000 · S/N 24683N64HGWagner William · Oklahoma City, OKBuilt 2000 · S/N 60152N64HSEdgefinders LLC · Littleton, COS/N 719N64JFLaskey Peter W · San Antonio, TXS/N 23701N64JLMay Michael W · Billings, MTBuilt 1978 · S/N 20-1251N64KBLee Scott D · Mcloud, OKBuilt 1959 · S/N 23-1665N64KMWhitehead Michelle W · Centralia, WABuilt 1997 · S/N KM-2N64KVVilendrer Kent S · Eden Prairie, MNBuilt 2003 · S/N 23078N64LCDurham Jason K · Springfield, MOBuilt 2004 · S/N 21836N64MKraft Ronald S · Albuquerque, NMBuilt 1956 · S/N 23-534N64MMPrins Dennis A · South Lake Tahoe, CABuilt 2001 · S/N 22554N64MSTilko Stanley L Jr · Butler, PABuilt 1973 · S/N 28-7305466N64PDPapa Delta LLC · Eddyville, KYBuilt 1979 · S/N 17272996N64PPG3aero LLC · Chesapeake, VABuilt 1998 · S/N 60007N64RVN64rv LLC · Tahlequah, OKBuilt 2000 · S/N 4033N64SAWilson Cliff · Harrison, IDS/N 002N64SBCrisp Steven J · Chewelah, WAS/N 812N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345
Back to AD 79-10-03 R2