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.

N5CMBramall Buster I · Waxahachie, TXBuilt 1973 · S/N 17262655N5DDSeghetti Brant C · San Tan Valley, AZBuilt 1974 · S/N AF17448714N5DPN5dp LLC · Ann Arbor, MIBuilt 1973 · S/N 28-7405033N5EECristal Air Inc · Wilmington, DEBuilt 1993 · S/N 172N5FMWillis Nelson W · Lebanon, TNBuilt 1994 · S/N 0001N5GJNorthampton Lsa LLC · Northampton, MABuilt 1978 · S/N GA7-0006N5GNNeu Lawrence R · Marion, TXBuilt 1977 · S/N XX5N5JBucher John R · Rch Palos Vrd, CABuilt 1966 · S/N 300N5JCSink Abram T · Hillsboro, OHBuilt 1982 · S/N 518N5JNOcchiuzzo Joseph A · Holyoke, MAFirst renewal noticeBuilt 1963 · S/N 28-1528N5KFSneddon Dale R · Carthage, MOBuilt 1986 · S/N 65N5LGStuller Dennis · Fort Denaud, FLBuilt 1966 · S/N 28-22238N5MDDunn Vincent K · Salem, ORBuilt 1966 · S/N 3317N5NSN5ns LLC · Payson, AZBuilt 1995 · S/N NEALN5PTMunson George R · Westhampton, MABuilt 1972 · S/N 17260628N5RJPilkington Lawrence O · Portland, ORS/N 739N5RWToms Ronald C · Lena, LABuilt 1970 · S/N 17259649N5SKKershaw Spence M · Hollywood, FLBuilt 1975 · S/N 135-HN5SRRollins Jay A · Muncie, INBuilt 1978 · S/N 73059LFN5TEBythway William M · Painesville, OHBuilt 1968 · S/N 113N5UASenneker Robert L · Dorr, MIBuilt 2001 · S/N 25103N5VTEmaaduddin Mohammed · Yonkers, NYBuilt 1967 · S/N 28-23176N5VYFeatherstone Tony W · Denton, TXBuilt 1973 · S/N AA5-0462N5WDSonoma Valley Aircraft Inc · Vineburg, CABuilt 1980 · S/N 105DN5XJOmalley Theodore J · Willow, AKBuilt 1998 · S/N 1424N5XWLewis Everett D · Comfort, TXBuilt 2004 · S/N 10242N5YTKilian Jacob J · Anchorage, AKBuilt 2005 · S/N RML001N5YXRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1981 · S/N 17275266N5ZQHigher Powered Racing LLC · Port Saint Lucie, FLBuilt 2001 · S/N 612-320-358FBN5ZURegistered aircraftBuilt 1981 · S/N 18-8109005N5ZWVinnola Bruce L · Glenrock, WYBuilt 2005 · S/N 109N60003Faucette Douglas R · Fallon, NVBuilt 1978 · S/N M-2110N6000BYahner William P · Central Square, NYBuilt 1978 · S/N M-2108N6000PMoseley Timothy D · Calhoun, KYBuilt 1957 · S/N 23-1236N6000QInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 3221N6000WPort Townsend Aero Museum · Port Townsend, WABuilt 1963 · S/N 28-20000N6000ZGillette David A · Monticello, UTBuilt 2001 · S/N 24142N6001DJohnson Scott V · Scottsdale, AZBuilt 1956 · S/N 22-4652N6001PZarate Roger L · La Mirada, CABuilt 1959 · S/N 24-1095N6001QCurry Gary · Everett, WABuilt 1965 · S/N 3222N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118N6001VNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N M-2112N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123N6002SSouthern Adventures Inc · Stuart, FLBuilt 1979 · S/N M-2115N6002WPeppas George D Jr · Fort Wayne, INS/N 28-20002N6003CMiles Darren · Bonita Springs, FLBuilt 1979 · S/N M-2113N6003QOsborn John W · Cimarron, KSBuilt 1965 · S/N 3223
Back to AD 79-10-03 R2