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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N275AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11442 N275ACTsutsumi Erika E · Boston, MABuilt 1998 · S/N 1372-98 N275AMAerodynamic LLC · Aurora, ORBuilt 2022 · S/N 2881518 N275CBCalifornia Baptist University · Riverside, CABuilt 2025 · S/N 2881916 N275CCSellers Richard V · Byron, CABuilt 2001 · S/N 9922CC N275CWLunde Craig W · Fort Shaw, MTBuilt 1946 · S/N 1744 N275DBKrejci Ryan J · Sandstone, MNBuilt 1988 · S/N 275 N275DFAspen Ring LLC · Bloomington, INS/N 2518 N275DHHoward Henry · Justin, TXBuilt 2019 · S/N 136B-265B/266B-1347 N275DSMebane Alfred Holt IV Trustee · San Diego, CABuilt 2003 · S/N 40.275 N275FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020058 N275FLFox Leasing Group LLC · Hollywood, FLBuilt 2023 · S/N 4496564 N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631 N275JKKrol Jeffrey P · Somers, CTBuilt 1969 · S/N 28-26151 N275LESky Photoshop LLC · Winter Garden, FLBuilt 2026 · S/N 2858 N275MAFranzoy Steve · Salem, NMS/N 1014-2006 N275NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842097 N275PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10515 N275PTTruss Travis D · Stephenville, TXBuilt 1997 · S/N 18280088 N275RVMccutchan Philip · Mount Vernon, INBuilt 2006 · S/N 80275 N275TBDownwind LLC · Olathe, KSBuilt 1991 · S/N 1159 N275TMShank Lee M · Iron Station, NCBuilt 1979 · S/N 32-7940275 N275TXQualitair LLC Trustee · MichelstadtBuilt 2015 · S/N 172S11635 N275WYHeileman Michael P · Pewaukee, WIBuilt 2017 · S/N 3275 N27601Elkins Dennis E · Erie, COBuilt 2004 · S/N 6-3887 HDS N2760PDickerson Gary M · Homer, AKBuilt 1955 · S/N 22-3070 N2760VFinish Line - N2760v LLC · Edmond, OKS/N 177RG0686 N2760WHardin Robert S · Renton, WABuilt 1966 · S/N 1050 N2760YSanders Flight Training Inc · Jasper, ALBuilt 1958 · S/N TD-126 N2761PCarlin Thomas J · N Richland Hills, TXBuilt 1955 · S/N 22-3071 N2762MRaymond Mark A · East Jordan, MIBuilt 1946 · S/N 12-1158 N2762WRouth Frank D · Marion, NCBuilt 1966 · S/N 1052 N2762YFisher Global LLC · Conway, ARBuilt 1958 · S/N TD-129 N2763GWilko Air LLC · Van Wert, OHBuilt 1967 · S/N 459 N2764PBrine William R · Pahrump, NVS/N 22-3075 N2764YChennault Flying Services LLC · North Las Vegas, NVBuilt 1958 · S/N TD-128 N2765MExperimental Aircraft Association Chapter 1218 · Willow Springs, MOBuilt 1946 · S/N 12-1167 N2765QHoney B LLC · Hillsboro, ORS/N 28-7716121 N2765WBriseno Anthony · Virginia Beach, VABuilt 1966 · S/N 1168 N2766MDahl Jerome M · Iron River, MIBuilt 1977 · S/N 28-7816309 N2766PMarti Larry B · Rolla, MOS/N 22-3077 N2767MNew Ulm Flight Services LLC · Marshall, MNBuilt 1977 · S/N 28-7890266 N2767PMatta Sam · Brookshire, TXBuilt 1976 · S/N 255-76 N2767SLarsen Mark A · Carmel Valley, CABuilt 2003 · S/N 9126-A-1092 BB N2767WMorrow Frank D · Wooster, OHBuilt 1966 · S/N 1055 N2768VThree Spirit Ventures LLC · Wayne, PABuilt 1975 · S/N 177RG0691 N2768WGlenn Larry W · Bunn, NCBuilt 1966 · S/N 3355 N2769AParish Theodore P · Anchorage, AKBuilt 1952 · S/N 25017 N2769WHarper Leonard D · Peyton, COBuilt 1966 · S/N 3356 N276AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881811

Back to AD 81-18-04 R2