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.

N739WXAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17270875N739WYN739wy LLC · Cheyenne, WYBuilt 1978 · S/N 17270876N739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeBuilt 1978 · S/N 17270877N739XA7550g LLC · Birmingham, MIS/N 17270878N739XCAllen Danny T · Jonesboro, LABuilt 1978 · S/N 17270880N739XKAirways Aviation Inc · Grand Rapids, MNBuilt 1978 · S/N 17270887N739XLFlyrjf LLC · Weirsdale, FLBuilt 1978 · S/N 17270888N739XMEnstad Ordell J · Goldendale, WABuilt 1978 · S/N 17270889N739XSGorman Patrick M · Deerfield, OHBuilt 1978 · S/N 17270894N739XTS O W Aviation LLC · Crystal River, FLS/N 17270895N739XUTraining Mission Aviation Inc · New Tripoli, PABuilt 1978 · S/N 17270896N739XVAmaro Mark S · Mi Wuk Village, CABuilt 1978 · S/N 17270897N739XWWhole Life Wellness Center · Alpine, TXS/N 17270898N739YESundance Air Services Inc · Alameda, CABuilt 1978 · S/N 17270906N739YHMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270909N739YMHeritage Aviation LLC · Ankeny, IABuilt 1978 · S/N 17270913N739YRF&O Flight LLC · Calhoun, GABuilt 1978 · S/N 17270917N739YURrrr Aviation LLC · Bryan, TXBuilt 1978 · S/N 17270920N739YWPettit Toby B · Morehead, KYBuilt 1978 · S/N 17270922N739YZSocal Aviation Inc · Chino, CABuilt 1978 · S/N 17270925N739ZCP&B Aviation LLC · Watkins, COBuilt 1978 · S/N 17270928N739ZGR & R Aero Services Llcc · Eden Prairie, MNBuilt 1978 · S/N 17270932N739ZHFreeflight Aviation LLC · Allentown, NJBuilt 1978 · S/N 17270933N739ZLLefebvre Jeffrey S · Kaneohe, HIBuilt 1978 · S/N 17270936N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939N739ZRJw Horton Aviation LLC · Rogers, ARS/N R18201021N739ZSPryor James A · Bottineau, NDS/N 17270942N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949N73AGHarrison Albon Wayne Jr · Lake Jackson, TXBuilt 1951 · S/N 20-622N73ALHefel Lori A · Wichita, KSBuilt 1974 · S/N 177RG0559N73AXJensen Steven · Port Angeles, WABuilt 1990 · S/N 11024N73BCVnk Sky Inc · Dover, DEBuilt 1973 · S/N 28-7305263N73BWBravo Whiskey Holdings LLC · Lewis Center, OHBuilt 1977 · S/N 28-7816102N73BYRivas Taylor · Olympia, WABuilt 2018 · S/N 002N73CHAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13234N73CMMau Christine A · Niceville, FLBuilt 1997 · S/N 21891N73CPQuality Concrete LLC · Brentwood, TNBuilt 2003 · S/N 3232004N73CVLiberatore A H Bud · Eagle Point, ORBuilt 1973 · S/N C1 5-6-30N73DYoseph Barry L · Olympia, WABuilt 1973 · S/N 1BLN73DCTwin Aviation LLC · Liberty Hill, TXS/N AA1A-0418N73DXAj Airlift LLC · Arlington, MAS/N 2868N73ECBronisevsky Robert · Old Bridge, NJBuilt 1990 · S/N 1187N73ESWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 18283074N73FQAlaska Island Air Inc · Togiak, AKBuilt 1981 · S/N 32-8206007N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134N73FTBerecz Kevin · Parrish, FLBuilt 1978 · S/N AA5A-0662
Back to AD 81-18-04 R2