OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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.

N419WPHole Jeffrey Wayne · Stockton, CABuilt 1996 · S/N 1331N419XBellamy William J · Duluth, MNBuilt 1976 · S/N 7048CN419YBBlum Bradley R · Waukesha, WIBuilt 2011 · S/N 4566N41ABBauermeister Aida · Tw 10 SjaBuilt 1991 · S/N 3204N41ACPitts Flying Club Of Stoughton · Stoughton, WIBuilt 1979 · S/N 321GN41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N41AHHarding Kenneth H · Columbus, OHBuilt 1954 · S/N 22-1899N41ALMclain Aviation LLC · Lyons, GAS/N 32-7240107N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385N41BBVagabond Air LLC · Dover, DES/N 6007458061228N41BEVintage Aero Collection Inc · Wilmington, DEBuilt 2007 · S/N 1690N41BJJames Robert D · Anaheim, CABuilt 1991 · S/N 10036N41BKAmerican Classic Aero LLC · Kalispell, MTBuilt 1993 · S/N 1247N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41CSSanders Aviation Services LLC · Hedgesville, WVBuilt 1996 · S/N 20403N41DBryson Zachary · Redondo Beach, CAS/N AA5B0993N41DDDurbano David · Jackson, WYBuilt 2017 · S/N CC19-0019N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142N41DMMission Air LLC · Oklahoma City, OKBuilt 1959 · S/N 23-1566N41EBCoakes Randall S · Lafayette, INBuilt 2004 · S/N 40.445N41EKPrairie View Energy II LLC · Granite Falls, MNBuilt 1978 · S/N 32R-7885096N41EMBretscher Mark · Hinsdale, ILBuilt 1976 · S/N 177RG0923N41ERDeiulio Michael · Carle Place, NYBuilt 1978 · S/N AA5B0910N41FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272997N41GCmg Helicopters LLC · Summerfield, LABuilt 1969 · S/N 291097(67-16990)N41GBBoeing Co · Berkeley, MOBuilt 1987 · S/N 1161N41GLGiegler Adam J · Cypress, TXS/N 23924N41GPHoman Alan · Lake Geneva, WIS/N 400N41GSGolf Sierra LLC · West Palm Beach, FLBuilt 1980 · S/N 61P08098063419N41HBWalsh Bowen S · North Augusta, SCBuilt 1969 · S/N AA1-0277N41HDHerman Edward G · Pitkin, COBuilt 1979 · S/N 41N41HMSale Reported · Reno, NVSale reportedBuilt 2017 · S/N 73954N41HSStevens Randall L · Abilene, TXBuilt 2007 · S/N 101N41HYWillcutts William D · Greeley, COS/N 2168N41JAJersey Aero Club · Lakewood, NJBuilt 1997 · S/N 2843081N41JMAmerican Aviation Automotive Enterprises LLC · Lewes, DEBuilt 1982 · S/N 432N41JRDarnall Jeffery D · Jacksonville, FLBuilt 1993 · S/N 3172N41KFThomas Wayne · Powell, OHBuilt 1968 · S/N 28R-30505N41KKDale Aviation LLC · Wilmington, DEBuilt 1979 · S/N 6006477961205N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351N41LACathriner Richard J · Plano, TXBuilt 2009 · S/N 263-320-28N41LDThomas James A · Yukon, OKBuilt 1989 · S/N 41N41LSGendron Chistofer P · Prospect Park, PABuilt 1952 · S/N 20-862N41LYFedflyt LLC · Russell Springs, KYBuilt 2017 · S/N 30020N41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17269389N41MSJennings William K · Chandler, AZBuilt 1967 · S/N 28-22716N41MWWoodard Michael G · Northport, ALBuilt 1978 · S/N M-2103
Back to AD 81-18-04 R2