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.

N993MCTucker Bill F · Booneville, ARS/N 002N993PDCertified Aviation LLC · Morristown, NJBuilt 1999 · S/N 172S8306N993RMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLBuilt 1984 · S/N WERCO 0001N9940VSoco Aero Leasing LLC · Santa Rosa, CABuilt 1974 · S/N 17264566N9940WStaley Harvey Russell · Brandon, FLBuilt 1967 · S/N 28-23484N9941DPye Jenny · Roanoke, TXBuilt 1959 · S/N 18-6997N9941UParsons Stephen · Wellington, FLBuilt 1977 · S/N AA5A0341N9942GQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 31-7712088N9942QWarren John Russell · Los Alamos, NMBuilt 1975 · S/N 17265886N9942WMccafferty R Joseph · Winfield, MOBuilt 1967 · S/N 28-23486N9942YHardy John R · Wasilla, AKBuilt 1962 · S/N 150N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887N9943URandall Steve · Oakland, CABuilt 1977 · S/N AA5A0343N9943YDehlin James M · Roscommon, MIBuilt 1962 · S/N 143N9944CLarsen John E · Adrian, MIS/N S-48N9944DRed Baron LLC · Dickinson, NDS/N 18-7013N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888N99450Castellucci Jason G · Los Angeles, CABuilt 1989 · S/N 1200N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295N9945PBonner Richard A · Garrettsville, OHBuilt 1976 · S/N 18-7709011N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889N99465Farzam Hamid · Newington, CTBuilt 1985 · S/N 17276450N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890N9946WHangar 0205 Inc · Calhoun, GABuilt 1967 · S/N 28-23491N9947CLoftin Aviation Group LLC · Suwanee, GABuilt 1978 · S/N R18200489N9947WDwinal Gary Lee · Lisbon, MEBuilt 1967 · S/N 28-23492N9948QPemberton Addison J · Spokane, WABuilt 1954 · S/N 18-3557N9948UDully David F W · Fernandina Beach, FLBuilt 1977 · S/N AA5A0348N9949RJeca Flight LLC · Liberal, KSBuilt 1960 · S/N TD-388N994BCEast Coast Flyers LLC · Rockville, MDBuilt 1970 · S/N 28R-7135036N994CCStraight And Level Productions Inc · Bentonville, ARBuilt 2000 · S/N 9911CCN994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089N994DBBest Equipment Leasing LLC · Bakersfield, CAS/N 994N994FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881831N994KCCayton Sidney M · Aurora, NCBuilt 2006 · S/N 11083N994KSEegt Inc · Helena, MTBuilt 2001 · S/N 90058N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037N994MGBlack Swan Inc · Austin, TXBuilt 2004 · S/N T18208352N994USDelta Kilo Foxtrot LLC · Littleton, COBuilt 2005 · S/N 27-0349N994WWMabry Properties And Holdings LLC · Jonesboro, ARBuilt 1999 · S/N 17280719N994XList Martinus R · Wasilla, AKBuilt 2011 · S/N 994N99507Alyeska Helicopters LLC · Girdwood, AKBuilt 2002 · S/N 3386N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456N9950DSierra Charlie Aviation LLC · Sandpoint, IDS/N 22-6738N9950QTymitz Peter A · Eagle River, AKBuilt 1955 · S/N 18-3563N9950WPlane Jane Aviation LLC · Lincoln, NEBuilt 1967 · S/N 28-23495N9950YAnders Rod D · Wasta, SDS/N 7GCB-156N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459
Back to AD 87-10-06 R1