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.

N7122RSimmons Heating And Air Conditioning LLC · Summerville, SCBuilt 1966 · S/N 28-21823N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823N7123UMatherly Frank · Greenbrier, TNBuilt 1964 · S/N 2742N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124LTriad Management Group LLC · Papillion, NEBuilt 1974 · S/N AA5-0624N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825N7125LCulbertson Lloyd K · Phillipsburg, KSBuilt 1973 · S/N AA5-0425N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425N7125WRavelli Sidney · Salem, OHBuilt 1962 · S/N 28-922N7126DKintner Daniel S · Conyers, GABuilt 1957 · S/N 22-4986N7126RLeonard Justin P · Charleston, SCBuilt 1966 · S/N 28-21827N7127BGeorge William A · Denton, TXBuilt 1956 · S/N 22-4345N7127RGreen William A · Memphis, TNS/N 28-21828N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828N7128LUrocopters Inc · Lancaster, CAS/N AA5-0428N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428N7128URegistration Pending · Billings, MTRegistration pending, canceledBuilt 1992 · S/N 889N7128WVan Curen Mary Ann · Owasso, OKS/N 28-925N7129DBusse Charles U · Cary, ILBuilt 1959 · S/N 22-4989N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129PBachand Cade C · Dickinson, NDBuilt 1960 · S/N 24-2292N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N7129RLinn Stephen K · Evergreen, COBuilt 1966 · S/N 28-21830N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712DTBrown Charles A · Boise, IDS/N 575N712LDia Development LLC · Mesa, AZBuilt 1956 · S/N 18-5082N712PJason Schwitters Farm Inc · Clara City, MNBuilt 1947 · S/N 12-1670N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676N712WHWhiskey Hotel LLC · Marengo, ILBuilt 1991 · S/N 1712N7130DSorenson Gregory John · Hope, AKBuilt 1957 · S/N 22-4992N7130WRoye Bart L · Slaton, TXBuilt 1962 · S/N 28-928N7131BWeisel Jeffrey W · Prescott, AZBuilt 1956 · S/N 22-4350N7131LMalof Matthew P · Falls Church, VABuilt 1974 · S/N AA5-0631N7132BConsolini Joseph · Driggs, IDBuilt 1964 · S/N 22-4351N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N7132RGreydanus Samuel E · Holland, MIBuilt 1966 · S/N 28-21833N7132VCrowley Preston R · Northport, ALBuilt 1974 · S/N 20-0033N7132WN7132w LLC · Lewes, DEBuilt 1962 · S/N 28-930N7133LHutchins Perry L · Little Rock, ARS/N AA5-0433N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433N7133VKing Mitchell Earl · Columbus, MSBuilt 1974 · S/N 20-0034N7133WSale Reported · Tomahawk, WISale reported, pending cancellationBuilt 1962 · S/N 28-932N7134CUS Flight Academy International Inc · Post, TXS/N 28-7625070N7134DSprenger Mark R · Eagle River, AKBuilt 1957 · S/N 22-4997N7134LCook'S Aviation LLC · Conover, NCBuilt 1973 · S/N AA5-0434N7134REney Brian P · Malibu, CABuilt 1966 · S/N 28-21835
Back to AD 80-04-03 R2