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.

N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410N8861WFrancavilla Charles · Fremont, CABuilt 1964 · S/N 28-10416N8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715293N8862LTisdale Matthew · Alameda, CABuilt 1974 · S/N AA1B-0362N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717N8862TAdams Donald L · Huntsville, ALBuilt 2010 · S/N 72640N8862YState Of Montana · Helena, MTBuilt 1973 · S/N 18-7409026N8863Lilly Daryl A · Winterset, IABuilt 2010 · S/N 40458N8863CClearsky II LLC · Tyler Hill, PABuilt 1953 · S/N 22-1494N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037N8863FCain James W · Big Rapids, MIS/N 63-0243N8863WPratt William D · Cashmere, WAS/N 28-10418N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038N8864LArnold Charles E · Lowell, MABuilt 1974 · S/N AA1B-0364N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19N8865CMayo Jesse J · Fairbanks, AKS/N 20-1034N8866CEckels Shaun R · Pickerington, OHBuilt 1953 · S/N 20-1031N8866FReynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 0242N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251N8866WPalmer Todd J · Sherrills Ford, NCBuilt 1964 · S/N 28-10421N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729N8867PAnderson Keith C · Puyallup, WABuilt 1970 · S/N 18-8867N8867WPayne Jason S · Overgaard, AZBuilt 1964 · S/N 28-10422N8867YPiper Thirty Nine LLC · Glasgow, MTBuilt 1970 · S/N 39-22N8868Hodges Jay W · Graham, TXBuilt 1973 · S/N 931-73N8868EArizona Soaring Inc · Maricopa, AZBuilt 2022 · S/N LA-260-21063N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354N8868PBurrough Haus Properties LLC · San Marcos, TXBuilt 1965 · S/N 24-4325N8868WBolton Barbara A · Alameda, CABuilt 1964 · S/N 28-10424N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731N8869WA&O Properties LLC · Harlan, IAS/N 28-10425N8869YCome Fly Away LLC · Waterloo, ILBuilt 1970 · S/N 39-24N886ABWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 17281516N886ACAir Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881397N886ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496323N886BNairn Bryan D · Edgewood, WABuilt 2001 · S/N 21963N886CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 18283126N886CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281341N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262N886EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12813N886JBRegistered aircraftS/N 30058N886JHJpj Aviation Holdings LLC · Wilmington, DEBuilt 1981 · S/N 32R-8213006N886PBarrons Aviation Services LLC · Henderson, NVBuilt 1962 · S/N 2328N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944N886RMFalkenberg Glenn R · Livonia, MIBuilt 2018 · S/N SUV104N886RVBazazan Mehrdad D · Fredericksburg, VABuilt 1994 · S/N 21707N886SACumbass David Shane · Douglas, GABuilt 2000 · S/N 0004N886SBWhitney Matt Gene · Watertown, SDBuilt 2026 · S/N 92 M
Back to AD 81-18-04 R2