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.

N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216N2817D2b Group LLC · West Dundee, ILBuilt 1979 · S/N 28-7990455N2817LHopkins Dennis L · Bark River, MIBuilt 1979 · S/N 28-7990456N2818AHengemuhle Ronald J · Long Prairie, MNBuilt 1979 · S/N 28-7990459N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462N2818PHancock Timothy R · Malinta, OHBuilt 1955 · S/N 22-3111N2818SAviator Antics LLC · Grand Forks, NDBuilt 1979 · S/N 28-7990466N2818TLb33 LLC · Helena, MTBuilt 1972 · S/N 28-7225239N2818XBarr Suzanne Renee · Cape Coral, FLBuilt 1979 · S/N 28-7990467N2818ZJohnston Charles W C · Newfield, NJS/N 22-6811N28199Guppy Aviation LLC · New Smyrna Beach, FLBuilt 1990 · S/N 1062N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469N2819LMason Timothy F · Effingham, ILS/N 1116N2819PRector David F · Akron, OHBuilt 1955 · S/N 22-3112N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819N2819TMelvin Haigis Jr · Bardstown, KYBuilt 1972 · S/N 28-7205227N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219N281BAnderson David R · Sycamore, ILBuilt 1959 · S/N 140N281CFCharlie Foxtrot Corp · Colleyville, TXBuilt 1977 · S/N 28-7816111N281DMBalducki James B · Signal Hill, CABuilt 1999 · S/N 1258-99N281HPMuggles Ltd LLC · East Fallowfield, PABuilt 2000 · S/N 2843323N281KCFly Kilo Charlie LLC · New Century, KSS/N 28-8216130N281PCBlair Bobby G · Essex, MOBuilt 2003 · S/N 1342-2003N281RABluewater Airmotive Corp · Wilmington, DEBuilt 1976 · S/N 28-7615352N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820N2820XJones Michael S · Fremont, WIS/N 17700220N28214Wellum Jeffrey B · West Terre Haute, INBuilt 1978 · S/N AA5B0939N28216Ocampo Jose · Montgomery Village, MDBuilt 1990 · S/N 1063N28218Bottorff Todd N · Roachdale, INBuilt 1978 · S/N AA5B0942N2821ZLarson Sidner J · Tucson, AZBuilt 1959 · S/N 22-6826N28220Registered aircraftBuilt 1978 · S/N AA5B0943N28222Just Plane Erie LLC · Erie, COBuilt 1978 · S/N AA5B0945N28224Barchik Edward C · Huntington Mills, PABuilt 1978 · S/N AA5B0946N28226Brown Jeremy D · Angleton, TXS/N AA5B0948N28227Hicks Tony L · Bixby, OKBuilt 1978 · S/N AA5B0949N2822XPender Michael J · Marsing, IDBuilt 1967 · S/N 17700222N2822YThayer Robert N · Portola, CABuilt 1979 · S/N 28-7990471N28230Kozak Gary D · Downers Grove, ILBuilt 1978 · S/N AA5B0953N28236Cathmoir Ruari M · Forfar AngusBuilt 1978 · S/N AA5B0956N2823DOloteo Dennis R Jr · San Antonio, TXBuilt 1979 · S/N 28-7990472N2823E2lyons Enterprises LLC · Westlake, FLBuilt 1978 · S/N 17271335N2823VOnofre-Trejo Ray · Chicago, ILS/N 1151N2823XSpectron Aviation Inc · West Boylston, MAS/N 17700223N2823ZKennedy Richard A · Livonia, MIBuilt 1959 · S/N 22-6817N28240Cannon Mark E · Indialantic, FLBuilt 1978 · S/N AA5B0958
Back to AD 79-10-03 R2