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.

N8553CNext Flight Out Ltd · Wilmington, DEBuilt 1953 · S/N 18-2699N8554DParks Alan J · Homer, AKBuilt 1957 · S/N 22-5786N8554VPaulson Marshall R · Kenai, AKBuilt 1974 · S/N 1070-75N8555Bank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 44-8207002N8555WSottile Andre M · Monroe, MIBuilt 1963 · S/N 28-10069N8555YScharf Mark T · Rosamond, CAFirst renewal noticeBuilt 1968 · S/N 30-1702N8556VParis Charles F · Pioneer, LABuilt 1974 · S/N 794-75N8556WBeans And Cool Dude LLC · Denton, TXBuilt 1963 · S/N 28-10070N8557DWells Michael D · Wilton, MEBuilt 1957 · S/N 22-5789N8557HLloyd Davis Inc · Brackettville, TXBuilt 1985 · S/N 0460N8557PQuaal Ranch Inc · Sundance, WYS/N 24-4014N8557VBurton Michael B · Coweta, OKBuilt 1974 · S/N 496-75N8558LStar Ads Inc · Torrance, CABuilt 1971 · S/N 25-5418N8558WEmerson Scott D · Roseville, CABuilt 1963 · S/N 28-10072N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559CJones Donald T · Barrigada, GUS/N 18-2711N8559EFlynn Mark K · Quinton, VABuilt 1959 · S/N 7HC-8N8559NJohnson Arnold R · Mina, SDBuilt 1969 · S/N 28-11357N8559VHolub Mark A · Dallas, TXBuilt 1974 · S/N 307-75N8559WKelcher Colton C · Olympia, WABuilt 1963 · S/N 28-10073N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174N855BDThompson Contracting Inc · Peachtree City, GABuilt 1998 · S/N 18280327N855CPVector Air LLC · Erie, COBuilt 1998 · S/N 17280461N855EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13231N855GKUavionix Corp · Bigfork, MTBuilt 2017 · S/N 72581N855LSAir First LLC · Kalispell, MTBuilt 1996 · S/N 0260N855MPPerez Mario · Oak View, CABuilt 1978 · S/N AA1C0165N855PCMcalee Dennis E · Defiance, MOBuilt 2008 · S/N 70970N855REBrowne Thomas J · Grass Valley, CABuilt 1986 · S/N MOORS 0001N855SPKirschner Joel D · Clarkesville, GABuilt 1981 · S/N R18201792N855TSSteier Tim A · Blue Earth, MNBuilt 2005 · S/N 0001N8560CGuy James L P · Wasilla, AKBuilt 1953 · S/N 18-2713N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560LKnutson Wayne R · Thompson, NDS/N 25-4981N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N8560WSafrit Christopher · Midlothian, TXBuilt 1963 · S/N 28-10053N8561NPorter Louisa · San Diego, CABuilt 1970 · S/N 28-11359N8561VParatus Air Inc · Auburn, INBuilt 1985 · S/N 0484N8561WMarble William R · Sparks, NVBuilt 1963 · S/N 28-10059N8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1957 · S/N 18-6212N8562NLorox Llp · Wishek, NDBuilt 1970 · S/N 28-11360N8562PRegistration Pending · Waukee, IARegistration pendingBuilt 1965 · S/N 24-4019N8563CPearson Ronald M · Sutton, AKS/N 18-2712N8563WRoche Daniel · Bellefonte, PABuilt 1963 · S/N 28-10075N8563YJohnson Richard · Fort Lauderdale, FLBuilt 1985 · S/N 1110N8564FRmi Air LLC · Ocilla, GABuilt 1976 · S/N 28-7715282N8564NEby Leo V · Clearville, PAS/N 28R-7135112N8564VWarfield Gerald Alan · Saltillo, MSS/N 1049-74N8564WBinns George E · Hackettstown, NJBuilt 1963 · S/N 28-10076
Back to AD 81-18-04 R2