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.

N555WRCentral Ridge Consulting Inc · Beverly Hills, FLBuilt 1994 · S/N 20187N555WUChapman Leland R · Carencro, LABuilt 2000 · S/N 23897N555WWAdams John G · Marietta, GABuilt 1976 · S/N 177RG1032N555XCTriple Five Air LLC · Redwood City, CABuilt 2004 · S/N S 52N555XPTri Air Inc · Aulander, NCBuilt 1999 · S/N 2032N555YFRathje Norm · Wills Point, TXBuilt 2004 · S/N 70049N555YSEdb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10638N555ZFuller Michael B · Winter Garden, FLBuilt 1952 · S/N 18-913N555ZHWurth Gary P · Rochester, NYS/N 17268439N555ZMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N CC19-0011N555ZWGrenda Adam J · King Salmon, AKBuilt 2010 · S/N HSC-2010-01N55605Parrish Don A · Plains, TXBuilt 1973 · S/N 28-7325440N55606Falcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325441N55608Thunderbird Aviation LLC · Shawnee, OKS/N 28-7305423N5560FVandyke Jason M · Gettysburg, PABuilt 1968 · S/N 28-24900N5560JSanilac Air LLC · Applegate, MIS/N 32-1025N5560MA-1 Auto Reyclers · Columbia, MOBuilt 1967 · S/N 097N55610Luxury Aviation LLC · Butler, PABuilt 1973 · S/N 28R-7335258N55613Holmquist Hugh R · Burwell, NEBuilt 1973 · S/N 28-7310151N55617Critchett Reggie D · Sterling Heights, MIBuilt 1973 · S/N 28-7325431N55618Keller Paul D · Burlington, CTBuilt 1973 · S/N 28-7325443N5561QRoberson Richard J Jr · Panama City, FLBuilt 1965 · S/N 2969N5561ZHoward David D · Winner, SDBuilt 1962 · S/N 22-9358N55621Wood Steve · Fresno, CABuilt 1973 · S/N 28-7325446N55622Detor Properties Inc · Rochester, NYBuilt 1973 · S/N 28-7305426N55623Vector Aviation Services LLC · Groesbeck, TXBuilt 1973 · S/N 28-7305427N55628Ag Air Squadron Two LLC · Saint Joseph, ILBuilt 1973 · S/N 28R-7335261N5562FTom Brian A · Santa Clarita, CABuilt 1968 · S/N 28-24902N5562UWilkosz Robert · Tampa, FLBuilt 1969 · S/N 28-26288N5563MJudkovitz Shmuel · Brooklyn, NYBuilt 1967 · S/N 100N5563PVahey James T III · Loxahatchee, FLBuilt 1958 · S/N 24-627N5563QFishero John D · Spring, TXBuilt 1965 · S/N 2970N5563UBlair James S · Beltsville, MDBuilt 1970 · S/N 28-26882N5563ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1962 · S/N 22-9360N55640Adams Charles G III · Tawas City, MIBuilt 1973 · S/N 28-7305430N55641Gizzy LLC · Fish Creek, WIBuilt 1973 · S/N 28R-7335263N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439N5565FHenley Brett · Manchester, TNBuilt 1968 · S/N 28-24905N5565JPerez Luis M Trustee · Corona, CAS/N 32-982N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292N55660Cifuentes Julio · Naples, FLS/N 28R-7335268N55665Bramley Matt J · Mesa, AZBuilt 1973 · S/N 28-7310123N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438
Back to AD 81-18-04 R2