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.

N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N88156Wilcox Aerial Applications Inc · Tilden, NEBuilt 1974 · S/N 730-74N8815NJenkins Roger Clayton II · Plain Dealing, LABuilt 1969 · S/N 28-25663N8815UHendrickson Tyrel L · Chester, MTBuilt 1983 · S/N DW-1-0094-83N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N88161Jordan Jay S · Wasilla, AKBuilt 1974 · S/N 84-74N88165Becker Aaron S · Santa Cruz, CABuilt 1974 · S/N 731-74N8816CNye Brian M · Independence, ORS/N 22-1427N8816JHuff Roger A · Johnstown, OHBuilt 1965 · S/N 28-2770N8816LWindy City Soaring Association · Hinckley, ILBuilt 1971 · S/N 25-5321N88172Hughes Glenn D · Wrightsville Beach, NCBuilt 1974 · S/N 470-74N8817CSharon Ricky E · Roberta, GABuilt 1976 · S/N 28-7625132N8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1965 · S/N 28-2771N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N88181Oglesby Holdings LLC · Henrico, VABuilt 1974 · S/N 732-74N88182Dachnowicz Peter A · Avon, CTBuilt 1974 · S/N 471-74N88184Delmolino Kevin R Sr · Walkersville, MDBuilt 1974 · S/N 472-74N88188Blair Keeley A · Erie, COBuilt 1974 · S/N 473-74N88189Ocean Aerial Ads Inc · Ocean City, MDS/N 89-74N8818CHalligan Austin C · Sidney, NES/N 22-1433N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976N88191Brown Dennis K · Reno, NVBuilt 1974 · S/N 474-74N88194Registered aircraftBuilt 1974 · S/N 91-74N88196Speer Jon H · Bryan, OHBuilt 1974 · S/N 1044-74N8819ETransition Aviation LLC · Hummelstown, PABuilt 1976 · S/N 28R-7635209N8819WBowen Donald M · Wasco, ORBuilt 1964 · S/N 28-10367N881ACFly Twin Comanche LLC · Peoria, AZBuilt 2001 · S/N 172S8818N881BBBittner Robert A · Pewaukee, WIBuilt 2011 · S/N 1N881BC125 LLC · Sandy, UTBuilt 2024 · S/N 642-2024N881CDWestern Pilot Service Inc · Phoenix, AZBuilt 1958 · S/N TD-95N881DCGoldfarb Martin · Scottsdale, AZBuilt 2002 · S/N 81403N881DSSeltman Jack A · Wichita, KSBuilt 1990 · S/N NEWBERG 0001N881FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496235N881GLActualized Business Solutions Inc DBA · California, MDBuilt 1968 · S/N 84N881GPPuckett Gregory N · Vesuvius, VABuilt 2006 · S/N 80081N881JBHammer Roger W · Seattle, WAS/N 1289N881JFGriffin Aviation LLC · Minneapolis, MNBuilt 2000 · S/N 18280748N881JRFinnegan Brian E · Waterloo, IABuilt 1996 · S/N 881N881KBAero Quest LLC · Olive Branch, MSBuilt 2023 · S/N 28020115N881KEPorter Equipment Holdings LLC · Magnolia, TXBuilt 2002 · S/N 10031N881LAAircraft Holdings LLC · Mesa, AZBuilt 2020 · S/N 172S12607N881LSNichols John B · Mena, ARBuilt 1966 · S/N 1N881MAHunt William E · Helena, MTBuilt 1988 · S/N M301-88N881PUTrustees Of Purdue University · West Lafayette, INBuilt 2025 · S/N 2881965N881RDOrchard Richard W · Sagle, IDBuilt 1981 · S/N 18-8109047N881RVKeeslar David L · Sturgis, MIBuilt 2004 · S/N 81574N881RWWilliams Summit LLC · Salmon, IDBuilt 1957 · S/N 18-6627N881SPIllinois State Police · Springfield, ILBuilt 2000 · S/N 18280784N881TAMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3023N881UJBurke Farm Management Service Inc · Waynesboro, GABuilt 2006 · S/N 40.649
Back to AD 81-18-04 R2