OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N268CSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 172S11266N268CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281258N268DASpartan Education LLC · Tulsa, OKBuilt 2002 · S/N 4496135N268DMRobinson Michael E · Chandler, AZBuilt 2005 · S/N 170N268EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13506N268FMRunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13268N268JCShaw Melvin · Annapolis, MDBuilt 1978 · S/N R18200213N268JGSpero Bruce A · Carson City, NVS/N 4N268LChilton Darren M · Pottsboro, TXS/N 268N268MAMasters Of The Air LLC · Salt Lake City, UTBuilt 1975 · S/N 28-7515338N268MCRegistered aircraftBuilt 2025 · S/N 22002N268MERegistered aircraftBuilt 2000 · S/N 18280776N268MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881366N268RJHudson David A · Jonesboro, ARBuilt 2010 · S/N 001N268RVRegistered aircraftBuilt 2006 · S/N 81313N268SStrohmeyer Charles R II · Lancaster, OHBuilt 2002 · S/N 80682N268TCline David R · Maryville, TNBuilt 1953 · S/N 18-2382N268TZHague Robert A · Rogers, ARBuilt 2020 · S/N 18283108N268ZMewmew Investment II LLC · Palo Alto, CABuilt 2023 · S/N 172S12947N26907Registered aircraftBuilt 1979 · S/N AA5A0804N2690CEdwards Zachary · Sylmar, CABuilt 1978 · S/N R18200214N2690QSilva Alberto · Titusville, FLBuilt 1970 · S/N 17259104N26913Alto Vista Flying Club · Cupertino, CABuilt 1979 · S/N AA5A0808N26915Doolittle Dean M · Bandera, TXBuilt 1979 · S/N AA5A0809N26917Nebrig Kenneth J Trustee · Prescott, AZBuilt 1979 · S/N AA5A0812N2691BPrewitt Scott S · King City, CABuilt 2005 · S/N 046N2691JObrien Terence · Bonney Lake, WABuilt 1993 · S/N 2233N2691MHartmaier Robert S Jr · Monroe Township, NJBuilt 1946 · S/N 12-1121N2691TSilkgate Aviation LLC · Yorba Linda, CABuilt 1971 · S/N 28-7205065N2691VHanlon James Bradley Trustee · Fallbrook, CABuilt 1975 · S/N 177RG0658N26922Feinberg Eugene M · San Jose, CABuilt 1979 · S/N AA5A0813N2692CStewart Chalmous · New London, NCS/N R18200215N2692MOnstott Norman V · Mount Pleasant, MIBuilt 1946 · S/N 12-1122N2692TWingsleasing LLC · Wichita, KSBuilt 1971 · S/N 28-7205072N2692VKlr Aircraft Sales LLC · Wilmington, DES/N 177RG0659N26935Bell William F · Norcross, GABuilt 1979 · S/N AA5A0822N26939Shaker M R · Green Bay, WIS/N AA5A0827N2693ZCoen Brady · Wiley, COS/N 268-78N26941Sumner Gary W · Knoxville, TNBuilt 1979 · S/N AA5A0839N26944Sunmer Gary W · Knoxville, TNS/N AA5A0829N26946Kramer Peter W · Copper Center, AKBuilt 1940 · S/N 5-16N26949Graham Michael L · Campbellsville, KYBuilt 1979 · S/N AA5A0832N2694GInspec Aviation Inc · Schwenksville, PABuilt 1980 · S/N 28-8090230N2694MSwartz William L · Cumb Foreside, MEBuilt 1946 · S/N 12-1206N2694PEllis Wendell K · Chugiak, AKS/N 18-4382N2694TStubby Wings LLC · Eden Prairie, MNBuilt 1971 · S/N 28-7205085N2694WDickerson Steven Micheal · Tipp City, OHBuilt 1966 · S/N 1009N26951Tunon Julian · Miami, FLBuilt 1979 · S/N AA5A0834N26954Registration Pending · Plantation, FLRegistration pendingS/N AA5A0837N26958Ely Michael D · Liberty, TXBuilt 1979 · S/N AA5A0838
Back to AD 81-18-04 R2