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.

N33HJMoore Michael E · Renton, WABuilt 1976 · S/N 1974N33HRHarpole Mark J · Sisters, ORBuilt 2000 · S/N 004N33HSN33hs LLC · Tallahassee, FLS/N 1HSN33HURunzel Brothers Aviation LLC · Bensenville, ILS/N 1310N33HYKiger Lance · Prairieville, LABuilt 2007 · S/N 2410N33JSaunders Dwayne E · Cary, NCBuilt 1973 · S/N JF-1N33JCMurphree Matthew · San Marcos, TXBuilt 1977 · S/N 28-7890144N33JDRiggs Alan Vance · Artesia, NMBuilt 1979 · S/N 32-7940159N33JFKimsey Thomas Wayne · Warner Robins, GABuilt 1965 · S/N 30-820N33JJFincor Inc · Miami Beach, FLBuilt 1972 · S/N AA5-0061N33JKMidway Aviation Co · Plant City, FLBuilt 1977 · S/N 7-0132N33JMKingdom Air Corps · Sutton, AKBuilt 1964 · S/N 28-10305N33JXProuty Timothy V Trustee · North Providence, RIBuilt 1977 · S/N AA5B0585N33KMathison John Michael · Fernley, NVBuilt 1977 · S/N 828N33KJPlane Fun Inc · Bow, WABuilt 1998 · S/N 23035N33KWWoods Erik K · Byers, COBuilt 2019 · S/N 40177N33LAOscar Tango LLC · Mesa, AZBuilt 2020 · S/N 172S12446N33LHKeller Charles T · Thaxton, MSBuilt 1968 · S/N 28-11098N33LJUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 15282023N33LTKelly Tony R · Aberdeen, MSBuilt 1997 · S/N 799-97N33LYBobo Robert A · Pullman, WABuilt 2001 · S/N 001N33NCRv Air Inc · Fresh Meadows, NYBuilt 2007 · S/N 81882N33PDStairs Karl O II · Livingston, TNS/N 1N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N33PLMcgraw Dennis S · Oakland, TNBuilt 2005 · S/N 60526N33PSN33ps LLC · Shoemakersville, PABuilt 1978 · S/N 32R-7885277N33PZRygiel Jerome A · Saint Cloud, FLBuilt 1975 · S/N 28-7615040N33RBJudy Charles E · Lawrenceville, ILBuilt 1999 · S/N 195699N33RTMcnamara Thomas Joseph · Santa Rosa, CAS/N 601-65-2171N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948N33SMoose Aviation LLC · Henderson, KYBuilt 1995 · S/N K066N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370N33SPCray Jaeger · Hilton Head, SCS/N 28-366N33SSRegistration Pending · Palmdale, CARegistration pendingBuilt 1966 · S/N 30-1104N33SVAviat Aircraft Inc · Afton, WYBuilt 2025 · S/N 3457N33SXGonzalez Richard J · Granbury, TXFirst renewal noticeS/N JONAS-0006N33SYFlight Level 510 LLC · El Dorado Hills, CABuilt 2004 · S/N 40.370N33TEDuncan Charles W III · Houston, TXBuilt 2011 · S/N 3137N33TGPiper LLC · Crystal Lake, ILBuilt 1975 · S/N 28R-7635006N33VLPalmer Thomas W · Boulder City, NVBuilt 1994 · S/N 11043N33VUVincennes University · Vincennes, INBuilt 2018 · S/N 4496431N33WKilcourse Jeffrey K · Tequesta, FLBuilt 1990 · S/N 233N33WAThompson Casey · Edmond, OKBuilt 1975 · S/N M-1619N33WJKite Air LLC · Staten Island, NYBuilt 1977 · S/N 32R-7780443N33WYOban Holdings LLC · Deephaven, MNBuilt 2010 · S/N 3094N33XXPtacek Stephen R · Estes Park, COBuilt 1938 · S/N 14N33YBBriggs Kent · Manhattan, KSBuilt 1963 · S/N 28-956N33YYMoore Keith V · Germantown, TNBuilt 1966 · S/N 28-3230N33YZJenkins Blake T · Lakeland, FLBuilt 1978 · S/N 24-0631N33ZCMarker Michael M Jr · Los Lunas, NMBuilt 1987 · S/N 3
Back to AD 81-18-04 R2