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.

N588DCDynoair LLC · Watertown, SDBuilt 1998 · S/N 18280243N588DSCox Joshua · Ormond Beach, FLBuilt 1973 · S/N 961-73N588LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020106N588LESmith Jason E · Calliham, TXBuilt 2004 · S/N 3588N588NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496233N588RVBird Aloft LLC · Sheridan, WYBuilt 2007 · S/N 40545N588SFIntrepid Helicopters LLC · Sylvania, OHBuilt 2006 · S/N 11034N588TEJefferts Steven R · Longmont, COBuilt 2007 · S/N 80132N5890DCouey Robert H · Anchorage, AKS/N 18-5315N5890LSturgeon Kenneth V · Winter Garden, FLBuilt 1972 · S/N AA5-0240N5890NSmith William Leonard · College Station, TXBuilt 1979 · S/N 14504N5890PDaniels David R · Anthony, NMBuilt 1959 · S/N 24-975N5890QDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1965 · S/N 3153N5890UKempton Lana Julia Trustee · Douglasville, GABuilt 1970 · S/N 28-26786N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508N5891DRiggs J'Ann · Wasilla, AKBuilt 1956 · S/N 18-5318N5891HFelske Michael J · East Troy, WIBuilt 1949 · S/N 16-512N5891LAlldridge Thomas H · Cochranville, PABuilt 1972 · S/N AA5-0091N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560N5891U2dwh LLC · Katy, TXBuilt 1970 · S/N 28-26727N5891WMarino Mario Mennona · King Of Prussia, PABuilt 1965 · S/N 28-2633N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394N5892UFeighl Engineering Group Inc · Hot Springs, ARS/N 28-26735N5892ZCarbiener Ross · Kewanee, ILBuilt 1963 · S/N 22-9756N5893HAmos Derek L · Helena, MTBuilt 1949 · S/N 16-513N5893LHegwood Jonathan E · Petal, MSBuilt 1972 · S/N AA5-0093N5893NKoehn Juergen A · Lago Vista, TXBuilt 1979 · S/N 14506N5893UCasper Gary · Spring Creek, NVBuilt 1970 · S/N 28-26706N5893WFinch Howell M Jr · Victoria, TXBuilt 1965 · S/N 28-2645N5893ZKugmach LLC · Holdrege, NEBuilt 1963 · S/N 22-9758N5894LTrueblood Terry L · Effingham, ILBuilt 1972 · S/N AA5-0094N5894QBlech Fritz · Grants Pass, ORBuilt 1965 · S/N 3155N5894ZRussell Webster K · Ridgeland, MSS/N 22-9759N5895HThompson Timothy G · Kenosha, WIBuilt 1949 · S/N 16-517N5895LWatkins Marion D · Mcdonough, GABuilt 1972 · S/N AA5-0095N5895NCommander Club LLC · Hudson, WIBuilt 1979 · S/N 14508N5895ZMerrick Richard W · Bernville, PABuilt 1963 · S/N 22-9761N5896PBurwell Brent C · New Ulm, TXBuilt 1959 · S/N 24-983N5896UGift Academy Inc · Vernon, TXS/N 28-26792N5897LCulver Christopher J · Rockmart, GABuilt 1972 · S/N AA5-0097N5897QBarsi Jeffrey D · Bonham, TXBuilt 1965 · S/N 813N5898LLamer Benjamin W · Ada, MIBuilt 1972 · S/N AA5-0098N5898QO'Neal Timothy L · Damascus, ORBuilt 1965 · S/N 3157N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213N5898WFrazier Justyn K · Mesa, AZS/N 28-2708N589APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843765N589CBBryan Curtis · Enumclaw, WAS/N 589N589LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020107N589NDUniversity Of North Dakota John D Odegard School · Grand Forks, NDBuilt 2026 · S/N 4496635N589RAMcgowin James E · Ball Ground, GABuilt 2007 · S/N 60589
Back to AD 81-18-04 R2