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.

N64FVStepec Edward J · Oregon City, ORBuilt 2004 · S/N 60114N64GHDivan Michael P · Bradbury, CABuilt 2000 · S/N 24683N64GRBarcena Daniel Albert · El Paso, TXBuilt 2015 · S/N 90944N64HECancienne Michael S · Kennesaw, GABuilt 1999 · S/N 5355N64HGWagner William · Oklahoma City, OKBuilt 2000 · S/N 60152N64HSEdgefinders LLC · Littleton, COS/N 719N64JFLaskey Peter W · San Antonio, TXS/N 23701N64JLMay Michael W · Billings, MTBuilt 1978 · S/N 20-1251N64KBLee Scott D · Mcloud, OKBuilt 1959 · S/N 23-1665N64KMWhitehead Michelle W · Centralia, WABuilt 1997 · S/N KM-2N64KVVilendrer Kent S · Eden Prairie, MNBuilt 2003 · S/N 23078N64KXBurris-Meyer Peter W · Titusville, FLBuilt 2002 · S/N 20969N64LBThermal Research Corp · Pensacola, FLBuilt 1999 · S/N 6028N64LCDurham Jason K · Springfield, MOBuilt 2004 · S/N 21836N64LRRuth Lawrence J · Roselle, ILBuilt 2015 · S/N 60451N64LTMeyer Thomas R · Double Oak, TXBuilt 2018 · S/N TRM-1N64MKraft Ronald S · Albuquerque, NMBuilt 1956 · S/N 23-534N64MCYounger Tyler James · Bakersfield, CABuilt 1995 · S/N 1N64MEShearer John R · The Dalles, ORBuilt 1999 · S/N MS-1N64MHJohafe Aviation LLC · Wilmington, DES/N S2122N64MMPrins Dennis A · South Lake Tahoe, CABuilt 2001 · S/N 22554N64MSTilko Stanley L Jr · Butler, PABuilt 1973 · S/N 28-7305466N64PCReed Allan T · Danville, INBuilt 1963 · S/N 24-3583N64PDPapa Delta LLC · Eddyville, KYBuilt 1979 · S/N 17272996N64PPG3aero LLC · Chesapeake, VABuilt 1998 · S/N 60007N64RFLake Seawolf LLC · King Of Prussia, PABuilt 1991 · S/N 126N64RVN64rv LLC · Tahlequah, OKBuilt 2000 · S/N 4033N64SAWilson Cliff · Harrison, IDS/N 002N64SBCrisp Steven J · Chewelah, WAS/N 812N64SDMorrison Brian D · Ferndale, CABuilt 1992 · S/N M20010N64SEBerry Jonathan W · Albuquerque, NMS/N 70628N64SFSafe Flight Instrument Corp · White Plains, NYBuilt 1977 · S/N 17268706N64SHEbersole Scott R · Corralitos, CABuilt 2004 · S/N 001N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345N64TBChristensen Phillip · Pensacola, FLS/N 505N64TD377 Supplies LLC · Argyle, TXS/N 30-170N64THRaincross Aviation Services Inc · Wilmington, DES/N 22619N64TLWadsworth Harley C · Albuquerque, NMBuilt 2000 · S/N 21180N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959N64TWPlane Fun LLC · Garretson, SDS/N 4636054N64TXRegistered aircraftBuilt 2008 · S/N 40378N64TZChapel Hill Flying Club DBA · Sanford, NCBuilt 1981 · S/N 28-8216081N64USJc Investors Group LLC · Coral Springs, FLBuilt 1974 · S/N 32-7440122N64VCByers Forrest K · Tucson, AZBuilt 2005 · S/N 40229N64VHHealey Richard · Tracy, CABuilt 1995 · S/N 743-95N64WCTrahan Stewart K · Little Rock, ARBuilt 1977 · S/N 32-7740095N64WDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 3246027N64WLLawrence Brian · Seal Beach, CABuilt 1997 · S/N 9612N64WMSeg Leasing LLC · Selinsgrove, PAS/N 61P-0360-112N64XPMarshall Greg J · Alexandria, VABuilt 2026 · S/N 42864
Back to AD 87-10-06 R1