OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N230DHHarris Dwain L · Pickens, SCBuilt 2019 · S/N 309N230DMGillespie Flying Services LLC · Trenton, SCBuilt 1997 · S/N 0325N230EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13092N230EZMeyer Daniel B · Redding, CABuilt 2012 · S/N 462N230FDConnolly Robert · Carmel, NYBuilt 2006 · S/N 1753N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011N230KGAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13468N230MAParker-Omalley Corp · Chatham, NYBuilt 2004 · S/N 953-2004N230MCMadelaire LLC · Bow, NHBuilt 1988 · S/N 1-010N230PKGyger Keith J · Granbury, TXBuilt 1987 · S/N 200-041N230RSAugust Aero LLC · Kalispell, MTS/N 023N230RVEast Tennessee Aviation LLC · Mountain City, TNBuilt 1973 · S/N 17261598N230SAStature Aviation LLC · Addison, TXBuilt 2025 · S/N 172S13435N230SBSierra Bravo Partnership · Liberal, KSBuilt 2011 · S/N 001N230SFWaters Robert · Albuquerque, NMS/N DMO 119N230SLOwens Mark · Kent, WABuilt 2017 · S/N 2298N230SUBoelte Aviation LLC · Wilmington, DEBuilt 2026 · S/N 4496639N230SVSwailes Craig · Taylor, MIBuilt 1979 · S/N 152-83257N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37N230THague Creek Aviation LLC · Phoenix, AZS/N 18-2344N230TDDickerson Timothy J · Woodlake, CABuilt 2020 · S/N 74551N230UBoard Of Regents · Norman, OKBuilt 2024 · S/N 4496587N230WChandler Charles G · Luray, VABuilt 2003 · S/N 2230N230WCKeiser John T · Santa Fe, NMS/N 010N230XHHowell William J · Portola Valley, CAS/N 28-7425416N23104Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13045N23107Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13105N23108Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13100N2310JRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1963 · S/N M-261N2310QPeterson Kevin · Roseville, CABuilt 1963 · S/N M-374N2311Price John C · Bennington, KSS/N GAM-1N23110Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13104N23116Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13106N23118Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13107N2311PCuller Stephen R · Winston Salem, NCBuilt 1955 · S/N 22-2722N2311QHagy Thomas Lee · Abingdon, VABuilt 1963 · S/N M-375N2311TAlanair LLC · Red Hook, NYBuilt 1971 · S/N 28R-7135197N2311XGoodrich Joshua A · Webster, MNBuilt 1991 · S/N 1972N23120Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13108N23124Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13111N23127Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13112N2312LSumerau Robert L IV · Lexington, SCBuilt 1963 · S/N M-138N2312NSale Reported · Maize, KSSale reportedBuilt 1991 · S/N 2018N2312PMoran Thomas D · Orchard Park, NYBuilt 1955 · S/N 22-2723N2312QMiller Kevin · Dover, DES/N M-376N2312ZDfr LLC · Giltner, NEBuilt 1962 · S/N M-35N23134Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13189N23137Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13191N2313NClark Randy L · Burlington, COBuilt 1979 · S/N 38-79A0781N2313PWright Michael · Hurricane, UTS/N 22-2724
Back to AD 81-18-04 R2