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.

N9223VQuick Janice L · Wrightwood, CABuilt 1969 · S/N 690060N9223WPierce Construction LLC · Shelby, ALBuilt 1967 · S/N 28-10891N9223XDhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11501N92247World Class Aviation Ltd · Bellefontaine, OHS/N 14022CN9224DAlleman Mark J Inc · Wilmington, DES/N 31N9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294N9224LAnalytical Technologies Inc · Miami, FLBuilt 1971 · S/N AA1A-0124N9224NBlanchard Aviation LLC · Nazareth, PABuilt 1993 · S/N 3213054N9224VBevington Carl R · Middle Point, OHBuilt 1969 · S/N 690053N9224WOppermann K Edward · Kingwood, TXBuilt 1967 · S/N 28-10892N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554N92258Mendez Leonel Jr · Corpus Christi, TXBuilt 1978 · S/N 38-79A0014N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447N9225LTerry Mark B · Henderson, NCBuilt 1971 · S/N AA1A-0125N9225MSmith Carl L · Danville, KYBuilt 1966 · S/N 1184N9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1989 · S/N 2841044N9225VDuncan Mark E · Marlton, NJBuilt 1969 · S/N 690048N9225WMosley Marvin C · Buckley, WABuilt 1967 · S/N 28-10893N92264Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11502N92266Dhs Operations LLC · Wilmington, DEBuilt 2014 · S/N 172S11503N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448N9226DClf Industries LLC · Thornton, COBuilt 1958 · S/N 22-6286N9226FLewis University · Romeoville, ILBuilt 1990 · S/N 4495011N9226HDebt LLC · Yuma, AZBuilt 1975 · S/N 17266026N9226SSpencer Montgomery L · Clinton, SCBuilt 1975 · S/N M-1723N9227JBinns George E · Hackettstown, NJBuilt 1966 · S/N 28-3297N9227MMullis Brent S · Garfield, GABuilt 1966 · S/N 3442N9227WMasterman Robert David · Chugiak, AKS/N 11097CN9228DLavender James R · Gainesville, TXBuilt 1958 · S/N 22-6288N9228JHail State Aviation LLC · Madison, MSBuilt 1993 · S/N 3213058N9228LRegistered aircraftBuilt 1993 · S/N 14024CN9228MSteubs Mike H · Portland, ORBuilt 1966 · S/N 1185N9228NEncore Jet Management LLC · San Antonio, TXBuilt 1993 · S/N 3213059N9228VDuval James A · Lima, OHBuilt 1969 · S/N 690049N92296Raymes Billy F · Stedman, NCBuilt 1995 · S/N 200007N9229BSsb Holdings LLC · Lake Wales, FLBuilt 1993 · S/N 3213060N9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391N9229DStevens Mark F · Ocean Springs, MSBuilt 1958 · S/N 22-6289N9229FCooke John W III · Carthage, TXBuilt 1997 · S/N 17280294N9229JUnterschuetz Phillip David · Ladysmith, WIBuilt 1966 · S/N 28-3299N9229MMadsen Jan Eric · Lincoln, NEBuilt 1966 · S/N 1186N9229SRegistered aircraftBuilt 1975 · S/N M-1724N9229WShackelford John S Jr · Roanoke, TXS/N 28-10897N922AKSanderson David C · Fort Davis, TXBuilt 1978 · S/N 15281807N922CTSweptwing Holdings LLC · Houston, TXS/N 1064N922DDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 1168N922EAButler Ronald A · Cumming, GAS/N 17263921N922ESSpears Esten W · Ocala, FLBuilt 2010 · S/N 80922N922KDDoughty Robert M · Earlville, ILBuilt 1993 · S/N 0058N922LHClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13554
Back to AD 81-18-04 R2