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.

N99BHBarker Aviation LLC · Ardmore, OKS/N 17260112N99BLLeaman Gary R · Lafayette, INBuilt 1999 · S/N 191N99BSEvans David M · Superior, WIBuilt 1977 · S/N 32R-7780432N99BVVickers Brian N · Bainbridge Island, WABuilt 2014 · S/N 3001N99BXTrinity Property Management LLC · Corvallis, ORBuilt 1993 · S/N 001N99DBGriffin John B · Marianna, FLFirst renewal noticeS/N 941N99DJMascagni Jerry Scott · Greenville, MSBuilt 2000 · S/N 23778N99DTHougham Roger F · Mc Lean, ILBuilt 1975 · S/N 1122-75N99DZFauquher Gabriel · Zionsville, INS/N 18045CN99ERYoder Thomas R Jr · Hatfield, INBuilt 1960 · S/N 001N99ESGorsuch Larry · Richland, WABuilt 1968 · S/N 32-1020N99EWClegg Kent R · Grace, IDS/N 477N99FRainbow Sports Inc · Enid, OKBuilt 1990 · S/N 012N99FDGolden Tree Flyer Corp · Wilmington, DEBuilt 1991 · S/N 787N99FPShort Jon P · Cullman, ALFirst renewal noticeBuilt 1978 · S/N 27-7854119N99GKInverted Holdings LLC · Newman, GABuilt 2023 · S/N 1207-2023N99GLCristy Daron James · La Jolla, CABuilt 1981 · S/N 1005N99HDRoodvoets Brian A · Lapeer, MIBuilt 1983 · S/N 1012N99HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1999 · S/N 172S8222N99HGSoutheastern Business Machines Inc · Baxley, GABuilt 1991 · S/N 001N99HLShaw James J · Loranger, LABuilt 1984 · S/N LIPSCOMB-0001N99HRSilver Express Co · Miami, FLBuilt 1978 · S/N 15282972N99HTKnowles John H · Iowa Park, TXS/N 099N99HUDoyle Investments LLC · Raleigh, NCBuilt 2024 · S/N 3435N99HVAerohawk LLC · Lawrence, KSBuilt 2005 · S/N 172S10090N99HYDiamond V Aircraft Interests LLC · Mountain Home, TXBuilt 2002 · S/N 2213N99HZSmoke Master Aero LLC · Tehachapi, CAS/N 23055N99JABean James E · Kings Park, NYBuilt 2005 · S/N 81110N99JDBurdette Dan G Trustee · Edmond, OKBuilt 2011 · S/N 91369N99JFPeep Air LLC · Rogers, ARBuilt 2009 · S/N 18282150N99JLMattson Eric J · Saint Paul, MNBuilt 1959 · S/N 24-1579N99JMRebellion Point Aviation LLC · Elizabeth City, NCBuilt 1973 · S/N 28-7325611N99JQQuayle John P · Pleasanton, CABuilt 1999 · S/N 1374-99N99JYKimmel Stephen G · Brevard, NCBuilt 2001 · S/N 22746N99KBKeller Bros Airport Inc · Lebanon, PABuilt 1990 · S/N 229N99KKAllen-Shinn Steven M · Larkspur, COBuilt 1980 · S/N 111N99KTColeman Paul Jay · Pace, FLBuilt 2000 · S/N 3RX046N99LBVolz Laura M Trustee · Williamsville, NYBuilt 1960 · S/N 24-2265N99LQTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1959 · S/N 834N99LYKanczuzewski Douglas J · Temecula, CABuilt 2022 · S/N 001N99MAHowell James M · Glendale, CABuilt 1991 · S/N CKA2N99MDJinkins Richard D · Rewey, WIBuilt 1955 · S/N 23-325N99NAPozzi Andrew E · Crescent City, CABuilt 1977 · S/N 17702697N99NCHrutkay Charles S · Scenery Hill, PABuilt 1968 · S/N 28-5044N99NRCarney Jeffery L Sr · Gallatin, TNBuilt 1974 · S/N 1069-75N99NXStewart Shelton O · Godley, TXBuilt 1998 · S/N 966N99PCDeffner David L · Mexia, TXS/N 1PCN99PF3g Classic Aviation Inc · Wilmington, DES/N 1-0006N99PGWilliams James R · Batesville, INBuilt 1978 · S/N 17272044N99PJLarose Gary R · Anchorage, AKS/N 18-7509141
Back to AD 81-18-04 R2