AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716N9220SWard 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-3291N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718N9221WWadi-Ramahi Shadi J · Evansville, INBuilt 1967 · S/N 28-10889N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719N9222QGood 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 2811042N9223FMckeeman Kevin · Abilene, KSS/N 14039CN9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293N9223VQuick Janice L · Wrightwood, CABuilt 1969 · S/N 690060N9223WPierce Construction LLC · Shelby, ALBuilt 1967 · S/N 28-10891N92247World Class Aviation Ltd · Bellefontaine, OHS/N 14022CN9224DAlleman Mark J Inc · Wilmington, DES/N 31N9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294N9224NBlanchard Aviation LLC · Nazareth, PABuilt 1993 · S/N 3213054N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721N9224VBevington Carl R · Middle Point, OHBuilt 1969 · S/N 690053N9224WOppermann K Edward · Kingwood, TXBuilt 1967 · S/N 28-10892N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447N9225MSmith Carl L · Danville, KYBuilt 1966 · S/N 1184N9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1989 · S/N 2841044N9225PRegistered aircraftBuilt 1967 · S/N 24-4722N9225VDuncan Mark E · Marlton, NJBuilt 1969 · S/N 690048N9225WMosley Marvin C · Buckley, WABuilt 1967 · S/N 28-10893N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015N9226CLane 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 17266026N9226KAlatis Nicholas C · Cincinnati, OHBuilt 1976 · S/N 32R-7680199N9226NGods Country Aircraft LLC · Trapper Creek, AKBuilt 1992 · S/N 4103CN9226SSpencer 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 3442N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717N9227WMasterman 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 14024C
Back to AD 87-10-06 R1