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.

N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328N5598WBall Dontel J · Tacoma, WAS/N 28-734N5599QFerraro Christopher · Croydon, PABuilt 1965 · S/N 2990N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299N559ESeitan Eduard · Chicago, ILS/N 28-3248N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096N559RVBrady Norman M · Port Orange, FLBuilt 2009 · S/N 90978N55ADSchrage Rodney L · Steamboat Springs, COBuilt 1977 · S/N 1006N55AUWallner Chris R · Petaluma, CABuilt 2003 · S/N 60537N55DPMagaw David N · Sacramento, CABuilt 1974 · S/N DP-3N55DYBrown Carl A · Las Cruces, NMBuilt 1992 · S/N 194N55EKMengel David M · Monticello, INS/N 1568N55EMIxi LLC · West Bloomfield, MIBuilt 1974 · S/N 28-7415328N55GBRivers Paul E · Shannon, ILBuilt 1979 · S/N 212056N55GTTurner William Hugh Vi · Belmont, CABuilt 1979 · S/N 5N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HNNaylor John H · Conway, ARS/N ONEN55HUKaihai Corp · Wilmington, DEBuilt 1999 · S/N 2046N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55JJPrivitt Bret · Fort Worth, TXBuilt 1974 · S/N 311-75N55KEMiller Charles A · Walla Walla, WABuilt 1990 · S/N 20081N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55MAGodwin Gerald R · Kountze, TXBuilt 2005 · S/N 2316N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103N55NDMeyer William M · Chicago, ILBuilt 1976 · S/N 606HN55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CCN55RCSmith Matthew E · Creston, IABuilt 1989 · S/N 288N55SHTiedeman Craig L · Seven Bays, WABuilt 1998 · S/N 55-483103N55TBKennedy Michael Allen · Oxnard, CABuilt 1966 · S/N 28-21634N55TWBeyer Arthur J · Cheektowaga, NYBuilt 1976 · S/N 248N55VLDarian Alexander L · Brightwaters, NYBuilt 1979 · S/N AA5B1065N55WAHudgens Terry L · Blockton, IABuilt 1972 · S/N 216N55WCHagan Jeremy D · Madrid, NEBuilt 1975 · S/N AA5B-0216N55XFCeb Enterprises LLC · Petal, MSBuilt 1972 · S/N 28-7325132N56001Citabria LLC · Missoula, MTBuilt 1982 · S/N VAC-184-82
Back to AD 80-04-03 R2