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.

N656BCSky Safety Inc · San Antonio, TXBuilt 2004 · S/N 40.441N656BFLong David T · Wake Village, TXS/N 310N656BWWeidinger Brendon · Warrenton, MOBuilt 2011 · S/N 60356N656CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281656N656DGD Gordon Aviation Inc · La Jolla, CABuilt 1977 · S/N R18200042N656DMKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270327N656EZJames Sean · Cresson, TXBuilt 1998 · S/N 1841-LN656FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020173N656GCotter Kevin G · Chico, CABuilt 2006 · S/N 90289N656JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N FR18200049N656JSLachausse Jeffrey B · Hilton, NYBuilt 2016 · S/N 219N656LRHays Robert E · Saint Paul, MNBuilt 2014 · S/N 656N656MFMelbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275818N656NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881156N656RBBas Part Sales LLC · Greeley, COBuilt 1997 · S/N S1744N656SSwann Kim Trustee · Toledo, OHBuilt 2013 · S/N 2255N656SFSkyfusion II LLC · Atlanta, GAFirst renewal noticeS/N 17271302N656SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8061N656TSN656ts LLC · Stuart, FLS/N 17275808N656WCT3 Aerosports LLC · Vian, OKBuilt 1996 · S/N 781-96N656WTAngelette Timothy B · Thibodaux, LABuilt 2009 · S/N 8-6901N65702Mitchell Myron W · Advance, NCS/N 607N65703Gonzalez Henry M · Miami, FLBuilt 1974 · S/N 608N65704Skywarrior Flight Training Inc · Pensacola, FLBuilt 1982 · S/N 17275824N65709Maverick Jet Leasing Corp · Wilmington, DEBuilt 1982 · S/N 17275827N6570HBritten Air LLC · Natchitoches, LABuilt 1975 · S/N 17265492N6570JJenkins Robert Martin · Westminster, MDBuilt 1968 · S/N 28-5023N6570LHack Mark K · Chatsworth, GABuilt 1983 · S/N M-2379N6570RBellas Business LLC · Kalispell, MTBuilt 1974 · S/N MC-298N6570WMurillo Raymond · Pico Rivera, CAS/N 28-20651N65710Beach Cities Aviation Academy LLC · Hawthorne, CABuilt 1982 · S/N 17275828N65714Ferrick James F DBA · Mechanicville, NYS/N 617N65716Rtd Aviation LLC · Hillsborough, NJBuilt 1982 · S/N 17275831N6571DBlazing Sun Aviation LLC · Encinitas, CABuilt 1979 · S/N 17272871N6571HHentges Dave · Canby, MNBuilt 1975 · S/N 17265493N6571JLima Alpha LLC · Pearcy, ARBuilt 1968 · S/N 28-5024N6571UCrabtree Martin L · Sedalia, MOBuilt 1962 · S/N 2353N65722Red River Aviation Services LLC · Altus, OKBuilt 1982 · S/N 17275835N65723Brutger Wayne · Little Falls, MNBuilt 1974 · S/N 624N6572DWalkowicz Eddie · Garland, TXBuilt 1979 · S/N 17272872N6572JFletchall Jeremy S · Queen Creek, AZBuilt 1968 · S/N 28-5025N6572WBoydstun Saylor Krystene · Brady, TXBuilt 1964 · S/N 28-20653N65730Chuchuca Espinoza Jorge A · Clifton, NJS/N 17275840N6573DPeabody Jeffery L · Vinemont, ALBuilt 1979 · S/N 17272873N6573JBeecher Bees Inc · Beecher, ILBuilt 1968 · S/N 28-5026N6573PCoil Ian M · Carroll, OHS/N 24-1695N6573UAlvis Michael E · Lumberton, NCBuilt 1962 · S/N 2355N6573WKing Isaac · Coahoma, TXBuilt 1965 · S/N 28-20654N6573YClendenen William M · Spencer, TNBuilt 1968 · S/N 27-3871N65741Flycarolina LLC · Charlotte, NCBuilt 1982 · S/N 17275846
Back to AD 87-10-06 R1