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.

N5099VNew Horizon Aviation Inc · Warwick, RIBuilt 1980 · S/N 172RG0449N509CBHouseman Jeffery D · Millersville, MOBuilt 2004 · S/N 001N509MSAhmed Asif · Canoga Park, CABuilt 1989 · S/N 509N509PCRich Lucas Aircraft Sales LLC · Lincoln Park, NJS/N 1487N509RWRegistered aircraftBuilt 2003 · S/N 90260N509SMCompton Stephen · Kennewick, WABuilt 1974 · S/N 17263807N509SWMeise Weston · Moses Lake, WABuilt 1964 · S/N 281N50AAOgonowski Kristine Staffeldt · Wasilla, AKBuilt 1974 · S/N 1001N50ACRegistered aircraftBuilt 1994 · S/N 1200-94N50AHBrass Jeffrey A · Ackley, IABuilt 2003 · S/N 110N50BTWade William T · Fairhope, ALBuilt 1974 · S/N 28-7415164N50BXAthena Aviation LLC · Greenville, SCBuilt 2003 · S/N 10227N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973N50DFCargille Joshua C · Kenosha, WIBuilt 1981 · S/N 122550N50DMMiller Cory L · Winnsboro, TXBuilt 1960 · S/N TD-332N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75N50ERFisher-Smith Jotham · Soquel, CABuilt 1978 · S/N AA5B0908N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154N50GWWomack Craig D · Carlsbad, CABuilt 1993 · S/N 20370N50HURovegno Paul C II · Burlington, NCBuilt 1996 · S/N 1320N50HYGrossman David G · Itta Bena, MSBuilt 2000 · S/N 2116N50JKPorter Judson · El Paso, TXBuilt 2001 · S/N 25405N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50KSShuman Kenneth R · Adrian, MIBuilt 2001 · S/N 20535N50MDBeifia Bedia Rafael · Winchester, VABuilt 1984 · S/N PA604N50MHWolpin Stephen A · Santa Paula, CABuilt 1984 · S/N 1403N50PFMitchell Kenneth A · Uniontown, PABuilt 1984 · S/N 28-8416084N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575N50PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N AA5B-0287N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087N50SELenfestey Thomas J Jr · Wasilla, AKBuilt 1974 · S/N 28-7415514N50TKTurner Miles David · Saginaw, TXS/N 001674N50TMRegistration Pending · Williamson, WVRegistration pendingBuilt 1972 · S/N MB-552N50WRPaphos Airways LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816642N50YRBrowning James M · Milaca, MNBuilt 1969 · S/N 28-25467N5100EWatson Lloyd Marshall · Sublette, KSBuilt 1978 · S/N 17271713N5100GAero Leasing LLC · Snohomish, WABuilt 1979 · S/N 17273548N5100HBurnett Robert Bruce · Anchorage, AKBuilt 1948 · S/N 14-104N5100LWilder Carl T · Budd Lake, NJBuilt 1967 · S/N 28-4372N5100SParks Victor Lee · Houston, TXBuilt 1971 · S/N 28-7125318N5100VSmith Gordon J · Manhattan, KSBuilt 1980 · S/N 172RG0450N51012Better Connect Systems LLC · Manheim, PABuilt 1973 · S/N AA5-0495N5101GWash Stephen · Franklin, TNBuilt 1967 · S/N 28-3969N5101MCarlson Noah · Seattle, WAS/N M-2033N5101RVan Steenis William W · Boulder City, NVS/N MB-788N5102DB & R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 17272422N5102ECag Aircraft Holdings LLC · Crystal River, FLBuilt 1978 · S/N 17271714N5102GHeussler Ryan · Rio Dell, CABuilt 1967 · S/N 28-4003N5102MRegistration Pending · West Melbourne, FLRegistration pendingBuilt 1978 · S/N M-2032
Back to AD 79-10-03 R2