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.

N9228MSteubs Mike H · Portland, ORBuilt 1966 · S/N 1185N9228NEncore Jet Management LLC · San Antonio, TXBuilt 1993 · S/N 3213059N9228PShillig Vance R · Colorado Springs, COS/N 24-4726N9228VDuval James A · Lima, OHBuilt 1969 · S/N 690049N9229BSsb 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 1186N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727N9229SRegistered aircraftBuilt 1975 · S/N M-1724N9229WShackelford John S Jr · Roanoke, TXS/N 28-10897N922BSCentral Airlines Inc · Leawood, KSBuilt 1966 · S/N 1598-207N922CTSweptwing Holdings LLC · Houston, TXS/N 1064N922DDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 1168N922EAButler Ronald A · Cumming, GAS/N 17263921N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017N922KDDoughty Robert M · Earlville, ILBuilt 1993 · S/N 0058N922MJAga Aviation LLC · Woodruff, SCBuilt 1997 · S/N 3257004N922PBillester Stephen E M · Parker, COBuilt 1974 · S/N 271HN922TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280249N922TJBowar Gary R · Miranda, SDBuilt 2008 · S/N 503-2008N92303Herman M Flink Inc · Mount Dora, FLBuilt 1993 · S/N 3213061N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290N9230MPernick Kevin · Milford, IABuilt 1966 · S/N 1187N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791N9230TProctor Richard P · Statesboro, GAS/N 11095CN9230VCloud Surfing Aviation LLC · Costa Mesa, CAS/N 690062N9230WLorenti Anthony Charles · Meriden, CTBuilt 1967 · S/N 28-10898N92318Flitepro Inc · Murrieta, CAS/N 17261561N9231AK&L Soaring LLC · Cayuta, NYBuilt 2020 · S/N 1N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729N9231VShaffer Lawrence · West Des Moines, IABuilt 1969 · S/N 690050N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562N9232BLaird Charles L · Adelanto, CABuilt 1958 · S/N 55032N9232GHarold H Bruner · Pinehurst, IDBuilt 1992 · S/N 19001CN9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305N9232RRogers Ricky R · Saint Francis, KSS/N 19003CN9232TSannella Joseph J · Missoula, MTS/N 19002CN9232VFerri Lawrence E · Lake Worth, FLBuilt 1969 · S/N 690056N9232WBarnum Eric E Trustee · Maumee, OHBuilt 1967 · S/N 28-10900N9233MSlone Buddie M · Waynesburg, KYBuilt 1966 · S/N 1188N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731N9233RBlash Gregory J · Corona, CABuilt 1978 · S/N R18200671N9233VRenner David C Jr · Belleville, ILBuilt 1969 · S/N 690063
Back to AD 87-10-06 R1