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.

N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N8809Velociraptor Aviation LLC · Toney, ALBuilt 1973 · S/N 929-73N88092Verhulst Charles · Reva, SDBuilt 1974 · S/N 723-74N88098Merriwether David E · Whitesburg, GABuilt 1974 · S/N 467-74N8809UDoyles Ag Services LLC · Two Buttes, COBuilt 1982 · S/N DW-1-0058-82N880AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13537N880CBJ-Airco LLC · Nashville, TNBuilt 1973 · S/N 17262582N880CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281870N880EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12807N880FWebfoot Aviation LLC · Chesterfield, MOBuilt 2023 · S/N 3417N880FTFlorida Institute Of Technology · Melbourne, FLBuilt 2000 · S/N 4496033N880GLNew England Airlines Inc · Westerly, RIS/N 2020N880HCBadger Heli Corp · Wilmington, DEBuilt 1989 · S/N 1208N880JGGray Richard D · White Stone, VABuilt 2022 · S/N 82827N880MABrekken Chris · Prescott, WIBuilt 2007 · S/N 2433N880MXCool Breeze LLC · Shelbyville, KYBuilt 2002 · S/N 002DCN880PUPurdue University Trustees · West Lafayette, INBuilt 2025 · S/N 2881949N880RVHamilton David S · Locust Grove, GABuilt 2003 · S/N 80001N880THAviation Peter Corp Of New York · New York, NYBuilt 1980 · S/N 172RG0522N880WSDepartment Of Inland Fisheries And Wildlife · Greenville, MEBuilt 2015 · S/N 172S11661N880XPAllen Ryan L · Lafayette, INBuilt 2026 · S/N 41308N88108Nor-Wes Inc · Shreveport, LABuilt 1982 · S/N DW-1-0068-82N8810CGroenwegen Bruce C · Snohomish, WABuilt 1953 · S/N 22-1423N8810DNorman Timothy J · Tofte, MNBuilt 1958 · S/N 22-5979N8810NShawl Robert M · Woodlake, CABuilt 1969 · S/N 28-25657N8810WLayne Andrew P · North Port, FLBuilt 1964 · S/N 28-10355N88110Lovas Thomas A · Anchorage, AKBuilt 1974 · S/N 725-74N88118Richard Thomas W · Greenville, MSBuilt 1974 · S/N 726-74N88119Aysta Nathan P · Hermantown, MNBuilt 1974 · S/N 606-74N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N88124West Aviation Inc · Creston, IABuilt 1982 · S/N DW-1-0078-82N88128Moore John T · Ward, ARBuilt 1982 · S/N DW-1-0080-82N8812BSale Reported · Missoula, MTSale reportedS/N DW-1-0073-82N8812DSowders Darwin G · Robinson, TXBuilt 1958 · S/N 22-5981N8812EHeiman Flying Services LLC · Summerfield, KSBuilt 1983 · S/N DW-1-0074-82N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N88130Harper Clayton E · Seabrook, TXBuilt 1974 · S/N 727-74N88134Morris William F B · Klamath Falls, ORBuilt 1974 · S/N 1040-74N88135Reed Aviation Inc · Iota, LABuilt 1982 · S/N DW-1-0085-82N8813KPrecissi Flying Service Inc · Lodi, CABuilt 1982 · S/N DW-1-0084-82N8813MMja Flight LLC · Justin, TXBuilt 1964 · S/N TD-571N8813NLangton Shane A · Boise, IDBuilt 1969 · S/N 28-25660N8813WOntiveros Carlos E · Prescott, AZBuilt 1964 · S/N 28-10359N88140Green Flying Machine LLC · Prior Lake, MNBuilt 1974 · S/N 1042-74N88144Hitchens Steven · Conesville, OHS/N 79-74N88149Cheshire Brad F · Flower Mound, TXS/N 157-74N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268N8814JCarey H Dwain · Cheyenne, WYBuilt 1965 · S/N 28-2766N8814NMarshall Lance A · Portland, ORBuilt 1969 · S/N 28-25661
Back to AD 81-18-04 R2