OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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:80-04-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:80-04-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.

N280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803N280TCNobles Gary D · Fairview, TXS/N 28-21227N280YSCrabtree Martin L · Sedalia, MOS/N BING-1N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66N2811ZHill Daniel A · Soldotna, AKBuilt 1959 · S/N 22-6804N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212N2812ZRubbert Randy C · Reynolds, NDS/N 22-6805N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2813TKamper Gregory S · Ripon, CABuilt 1972 · S/N 28-7225237N2814MBruggeman Michael J · Saint Paul, MNBuilt 1946 · S/N 12-1182N2814ZGibney Paul H · Palmer, MABuilt 1959 · S/N 22-6807N2815FKlopping William E · Apple Valley, CAS/N 28-7916438N2815PJohnson Trevor T · Somerset, WIBuilt 1955 · S/N 22-3108N2815ZBarnhill 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 AA5B0942
Back to AD 80-04-03 R2