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.

N921CTN921ct LLC · Elkton, KYS/N 18281220N921DCCarlson Donald A III · Lexington, TNBuilt 1975 · S/N AA5B-0039N921EZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 172S8499N921GDAir Charter Inc DBA · Culebra, PRBuilt 1974 · S/N 420N921JKShackleford Wayne D · Riverside, CABuilt 1982 · S/N 921-80N921JMFlight Equity LLC · Fayetteville, ARBuilt 2004 · S/N 10565N921KCRocket City Helicopters LLC · Brownsboro, ALBuilt 1992 · S/N 2180N921KPCenturion N709jm LLC · Minneapolis, MNBuilt 1978 · S/N R18200298N921LCCrum Robert W · Lake Havasu City, AZBuilt 1969 · S/N 28-25939N921LGHertz David · Dix Hills, NYBuilt 2012 · S/N 40790N921LJGossett Chase · Centre, ALBuilt 1977 · S/N 32R-7780449N921NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881885N921PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843268N921PCProppe Karl H · Needham, MABuilt 1992 · S/N 1809058N921RCCall Raymond T · Batesville, INBuilt 2016 · S/N 463N921RSSpry Mark W · Elkmont, ALBuilt 2020 · S/N 221MSN921SJDavis Brandon Grey · Huntsville, ALBuilt 2010 · S/N 20208N921TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280244N921TCBell Charles S · Fort Payne, ALS/N 23695N921TTRed Baron LLC · Middletown, DEBuilt 2001 · S/N 2012N921UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3566N921WC7 Corp · Orlando, FLBuilt 1964 · S/N 2878N921WJJones Wesley C · Yuba City, CABuilt 2016 · S/N 90822N921XPLengler Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 1905N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77N9220BSchmalenberger Jason R · Hebron, NDBuilt 1993 · S/N 3213048N9220CDixon Aviation LLC · Oakland, MDBuilt 1978 · S/N 32-7840091N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280N9220MBeaty David · Santa Fe, NMBuilt 1966 · S/N 1181N9220SWard Jessica · Southport, NCBuilt 1975 · S/N MC-380N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030N9221JJgms Rose LLC · Stamford, CTBuilt 1966 · S/N 28-3291N9221WWadi-Ramahi Shadi J · Evansville, INBuilt 1967 · S/N 28-10889N92228Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11498N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282N9222HDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11497N9222LTyler Timothy C · Wyoming, OHS/N AA1A-0122N9222QGood Shepherd Leasing Corp · Brooksville, FLBuilt 1993 · S/N 3213051N9222RWellman A Ryan · San Jose, CABuilt 1978 · S/N R18200670N9222SSvendsen James · Center Moriches, NYBuilt 1975 · S/N M-1718N9222VSoco Scuba LLC · Austin, TXS/N 690052N9222WJohnson Michael E · Tyler, TXS/N 28-10890N92236Garfoot William K · Verona, WIBuilt 1982 · S/N 0233N92239Kingdom Air LLC · Kalispell, MTBuilt 1993 · S/N 2811042N9223CDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11499N9223EDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11500N9223FMckeeman Kevin · Abilene, KSS/N 14039CN9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293N9223LHogan Fredrick C · Oviedo, FLBuilt 1971 · S/N AA1A-0123
Back to AD 81-18-04 R2