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.

N23WCSale Reported · Seagraves, TXSale reportedS/N 20448N2400Ticknor Rodney J · Bridgewater, IABuilt 1967 · S/N 28-4586N24005Tigerdawg Aviation LLC · Dawson, GABuilt 1977 · S/N M-1920N24006Keiper Mark D · Spring, TXBuilt 1977 · S/N MB-835N24010Fox Brent A · Janesville, WIBuilt 1980 · S/N 18-8009061N24018Schulte David L · State College, PABuilt 1977 · S/N M-1926N24019Orr Stevan J · West Bloomfield, MIBuilt 1977 · S/N M-1924N24020Maine Instrument Flight · Augusta, MEBuilt 1977 · S/N MB-838N24023R14alpha Aviation LLC · Dover, DEBuilt 2002 · S/N 24514N24025Birx Ethan S · Piedmont, SCBuilt 1977 · S/N MB-839N24026Albion-Edgerton Flyers Inc · Fort Atkinson, WIBuilt 1977 · S/N M-1922N24027Wilson Dwayne L · Arlington, TXBuilt 1977 · S/N M-1929N24029Bindas Ronald · Georgetown, TXBuilt 1977 · S/N MB-840N2402PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1956 · S/N 18-4261N2404PKirby Ronald S · Reno, NVBuilt 1955 · S/N 18-4266N24057Macaluso Raymond A · Sweetwater, TNBuilt 1977 · S/N M-1937N2405HPrevatt Stephen W DBA · Kodiak, AKBuilt 1979 · S/N 18-7909181N2405JHorne Donald Bayne Jr · Corpus Christi, TXS/N 18-7909118N2406JPorter Wade R · Durham, CABuilt 1979 · S/N 18-7909119N2406XBrumit John E Jr · Odessa, TXBuilt 2003 · S/N 01N240DMRussell Robert Q · Genoa City, WIBuilt 1977 · S/N 17269757N240MFMillis Ronald · Williamsburg, VABuilt 2002 · S/N 0024N240MKFly254 LLC · Waco, TXS/N 28-26527N240RDOrourke Donald A · Tucson, AZBuilt 2001 · S/N 5045N240SBPeacock Bradley B · Norco, CABuilt 2000 · S/N 01N240SMDance Bruce B · Carthage, MOBuilt 1985 · S/N 1-185N240SSStroup Robert L · New River, AZS/N 345-80N240WWelsh David G · Payson, AZBuilt 1987 · S/N 24N2410EKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17271272N2410PPerry William N · Anchorage, AKBuilt 1955 · S/N 18-4277N2411FAarow Aircraft Leasing LLC · Mcminnville, ORS/N 0549N2412RGagnon David D · New Market, ALS/N 28-5615N2413Gabardi Duane A · Manitou Springs, COBuilt 1963 · S/N 2624N2413TRing Michael E · Lake Village, INBuilt 1971 · S/N 28-7205053N2414PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4289N24153Mt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17275094N24155American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275290N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274N2417KDarley Vernon O · Peachtree City, GABuilt 2024 · S/N HC 0186N2417PMehling Craig · Hardin, MTS/N 18-4293N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241AWStewart Lawrence D · Council Bluffs, IABuilt 2004 · S/N 5614N241BDHanus David S · Mound, MNS/N 60477N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241DWGaither William W Jr · Shallotte, NCS/N 634RGN241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889
Back to AD 80-04-03 R2