OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N44VTNelson William R · Caldwell, IDBuilt 1994 · S/N 20121N44VVHampton Warrior II Inc · Shelter Island, NYBuilt 1980 · S/N 28-8116009N44WCWhite Eagle Investments LLC · San Jose, CABuilt 1995 · S/N 20242N44WKMaiden Robert M · Williamson, GABuilt 1983 · S/N 11144N44WLLitton Wade N · Townsend, MTBuilt 2026 · S/N 20510N44WMBloomfield Robert C · Anchorage, AKBuilt 1974 · S/N 18-7409095N44WZWild Blue Yonder LLC · Batavia, OHS/N 729N44XDDuffer David · Fallbrook, CABuilt 1999 · S/N 1054N44YYYankee LLC · Kasilof, AKBuilt 1979 · S/N 18-7909069N4500RWork Edward · Sneads Ferry, NCBuilt 1965 · S/N 28-21199N4500WMagalsky Jacob J · Wilsall, MTBuilt 1980 · S/N 18-8009019N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614N4501RNess James H · Phoenix, AZBuilt 1965 · S/N 28-21200N4503YSteppler Dean M · Culbertson, MTBuilt 1971 · S/N 18-8923N4504YCronin Monty A · Gettysburg, SDBuilt 1971 · S/N 18-8924N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810N4505RFayal Kenneth E Jr · Bend, ORS/N 28-21205N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206N4506TPettit Kenneth W · Madison, INBuilt 1972 · S/N 28-7225176N4506VRegistered aircraftBuilt 1979 · S/N 28-8090026N4507NGarnet Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 28-8090031N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032N4507TLoma Aviation LLC · San Diego, CABuilt 1972 · S/N 28-7205174N4507XVanny Ravy · Winchester, CABuilt 1976 · S/N 28-7625046N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813N4508XWestchester Flying Club Inc · Purchase, NYBuilt 1975 · S/N 28-7690026N4509YWolfrum John A · Two Rivers, AKBuilt 1971 · S/N 18-8930N450BASimmons Brian R · Heavener, OKBuilt 1981 · S/N M-2342N450FLMorriss Aviation LLC · Allen, TXBuilt 1971 · S/N 28-7125243N450JAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496150N450PMStroede Scott E · King Salmon, AKBuilt 1958 · S/N 22-6206N450RBurns Richard · Wasilla, AKBuilt 2003 · S/N 450RN450VVCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496113N4510AGarvey James R · Fairhope, PABuilt 1956 · S/N 22-3815N4510DCamwhit Air Corp · Montgomery, NYBuilt 1979 · S/N 28-8016015N4510RMcmichael Steven G · Eden, NCBuilt 1979 · S/N 28-8090036N4510YFrost John David Trustee · Anchorage, AKBuilt 1972 · S/N 18-8931N4511BGcbc LLC · Norman, OKBuilt 1979 · S/N 28-8090037N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619N4511YWab Air LLC · Boulder, MTBuilt 1971 · S/N 18-8932N4512LA&J Aircraft Leasing Inc · Burlington, COS/N 28-8016016N4512RElder Abuse Air Force · Rcho Sta Marg, CAS/N 28-21213N4512XSullivan Bradley · Tomball, TXBuilt 1975 · S/N 28-7625047N45134Last Chance Lance Auto Sales LLC · Ardmore, OKBuilt 1978 · S/N AA5B0627N45135Warren Jeremy D · Bloomington, INBuilt 1978 · S/N AA5B0829N4513DRkm Aviation LLC · Lexington, NCBuilt 1979 · S/N 28-8090038N4513NRspp Group LLC · Friendswood, TXBuilt 1978 · S/N AA5B0994N4513RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1965 · S/N 28-21214
Back to AD 80-04-03 R2