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.

N322CPPaul William D · Cadillac, MIBuilt 2005 · S/N S1875N322CSGlembot Troy M Trustee · Winchester, VABuilt 2012 · S/N 18282341N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545N322DRMcgrath James T · Campbell, CABuilt 2005 · S/N 81291N322DWAutry Michael D · Metuchen, NJBuilt 2015 · S/N 11384N322ERucinski Thomas · Paramus, NJBuilt 1992 · S/N 698-93N322EFRkm Aviation · Lexington, NCBuilt 2021 · S/N 28020031N322EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12782N322GEPierce Michael W · Leitchfield, KYS/N 0934N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096N322HYJk Air LLC · Las Vegas, NVBuilt 2019 · S/N 3322N322JK & M Aviation LLC · West Liberty, KYS/N 24-1316N322JWBravo Aircfraft LLC · Alpharetta, GABuilt 2026 · S/N 172S13521N322KLBuyair LLC · Valdosta, GAS/N 10220N322MLAshcraft Aviation LLC · Bay City, TXS/N 3572N322NDUn Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881749N322RAEuroamerican Development Group Inc · New York City, NYBuilt 1978 · S/N 13053N322RHRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 4952N322SHelfrick Edward W Jr · Elysburg, PABuilt 1995 · S/N 2005N322TBBlack Nelson T · Temple, TXBuilt 2010 · S/N 1N322TEEschmann Tim · Novinger, MOBuilt 2004 · S/N 18281372N322WHThurmond Robert Lee · Blessing, TXBuilt 2024 · S/N HC 094N322WMHurren Norman J · Applegate, MIBuilt 1997 · S/N 1362-97N322WYBarnette Jerry Jr · Richmond, KYBuilt 2014 · S/N 3222N322ZLafaille David A · Simi Valley, CABuilt 1991 · S/N WP001N32300Primary Flight Control LLC · Fleming Island, FLBuilt 1974 · S/N 28-7515118N32306Legacy Pilot Training LLC · Annandale, MNS/N 28-7515120N3230BYoder Ranches Llp · Karval, COBuilt 1954 · S/N 22-2059N3230FRegistered aircraftBuilt 1967 · S/N 670023N3230QArizona Cassidy E · North Platte, NEBuilt 1977 · S/N 28-7790448N3230TLsao LLC · Shelbyville, ILBuilt 1967 · S/N 17700530N3230WHagan Jackson · Wetumpka, ALBuilt 1965 · S/N 32-40N32314Fort Dodge Flight Support Inc · Fort Dodge, IABuilt 1974 · S/N 28-7525048N32318Feulner Lori · Hebron, NEBuilt 1974 · S/N 28-7515123N3231QCollins Gregory J · Appleton, WIBuilt 1977 · S/N 28-7725220N3231RAll2fly LLC · Atlanta, GABuilt 1969 · S/N 28R-31000N3231TGouse Frederick Earl II · Waxahachie, TXBuilt 1967 · S/N 17700531N3231WDouble F Enterprise LLC · Paullina, IABuilt 1965 · S/N 32-42N3231ZWestern Skyways Inc · Montrose, COBuilt 1959 · S/N 22-7176N32321Irvin Phillip Jerry · Winters, TXBuilt 1974 · S/N 28-7515126N32326Blair James J Jr · Brick, NJBuilt 1974 · S/N 28-7525050N3232BLink David J · Helena, MTS/N 22-2062N32332Warrior 74 LLC · Columbia, SCBuilt 1974 · S/N 28-7515129N32334N32334 Aviation LLC · Chandler, AZBuilt 1974 · S/N 28-7515130N32336Simmer Nicholas Lee · Rock Falls, ILBuilt 1974 · S/N 28-7525052N32337Pab Air Inc · Hialeah, FLBuilt 1974 · S/N 28-7515131N32338Rivera Filiberto Jr · Moses Lake, WABuilt 1974 · S/N 28-7515132N3233FPlank Lester L · Montgomery, INBuilt 1967 · S/N 670026N3233MBoniek Martin J · Glennallen, AKBuilt 1947 · S/N 12-2027N3233TByrne Gary W DBA · Georgetown, INBuilt 1972 · S/N 835-72
Back to AD 81-18-04 R2