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.

N93CMekolichick Jerry D · Whitehall, PABuilt 1969 · S/N 690039N93CDDe Leon Jonas · New York, NYBuilt 1993 · S/N 27-0153N93CFSink Abram T · Hillsboro, OHBuilt 1998 · S/N MK0052N93DASeptember Bravo Enterprises LLC · West Olive, MIBuilt 2004 · S/N 2102N93DECore Peak Consulting LLC · Moorcroft, WYBuilt 1994 · S/N SUT604N93DNRiseaero LLC · Florence, SCBuilt 1993 · S/N 712-93N93DSSrofe Danny D Jr · West Portsmouth, OHS/N 267 42 0708N93DTTolkach Dennis · Dunlevy, PABuilt 1993 · S/N 366-93N93EREdal Inc · Plantation, FLBuilt 1992 · S/N 10106N93FFPeauy Mike J · Chico, CABuilt 1996 · S/N 13N93GFRanieri Realdo · Mesa, AZBuilt 1993 · S/N 367-93N93GGGosser Chad K · Russell Springs, KYBuilt 1964 · S/N 385N93GMPrice Justin E · Charlotte, NCBuilt 1992 · S/N 2240N93GPHorizon Helicopters Inc · Newark, DEBuilt 2005 · S/N 2117N93GWRegistration Pending · Glenn, CARegistration pendingBuilt 2001 · S/N 1N93HBVranes Michael · Zephyr Cove, NVBuilt 1981 · S/N 18267768N93HUFugleberg Lance R · Portland, NDBuilt 1993 · S/N 1249N93HYBorrego Farms Inc · Valley Center, CABuilt 2004 · S/N 2281N93JSNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1972 · S/N 17260936N93KCT I M E Flight Inc · Heber Springs, ARBuilt 1992 · S/N 3213041N93KKMonmouth Area Flying Club · Lakewood, NJBuilt 1975 · S/N 17266160N93KNPataky Gabriel J · Sarasota, FLBuilt 1993 · S/N 2890174N93LDMcnabb Ernest Mark · Somerville, TNBuilt 1995 · S/N D0001N93LRSuchomel Charles F · New Carlisle, OHBuilt 1975 · S/N RN2851N93MCGabel Allan · Oxnard, CABuilt 2013 · S/N 71004N93MGCastle Aviation Inc · North Canton, OHBuilt 1979 · S/N 6006707961211N93MLAsher Kevin C · Wasilla, AKBuilt 1993 · S/N 4114-CN93MVWell Bilt Industries USA LLC · Ocala, FLBuilt 1979 · S/N 27-8054029N93MYReuterskiold Jerold L · Friendship, WIBuilt 1994 · S/N 21001N93PNHawkins Steven L · Grand Prairie, TXBuilt 1974 · S/N 32-7440091N93RFRegistered aircraftS/N 1787-LN93RJStamm David · Lake Almanor, CAS/N 4622130N93RPShafer Andrew · Phoenix, AZBuilt 1993 · S/N 21219N93RRReid Ronald T · Oxnard, CABuilt 2018 · S/N 91757N93RSJones Warwick L · Torrance, CAS/N 978N93RVMouliere Billy D · New Waverly, TXBuilt 1993 · S/N 20496N93SAOverbey Shane · Detroit, MIBuilt 1992 · S/N 1064N93SKHall William N Jr · Cocoa Beach, FLBuilt 2012 · S/N 71806N93SMVilla Aviation LLC · Alpharetta, GABuilt 2000 · S/N 1290-2000N93TBWarmkessel James R · Felton, CAS/N 541N93TEOlwell Cheryl · Bulverde, TXBuilt 1977 · S/N AA5B0475N93TJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28R-35026N93UGBellas Business LLC · Kalispell, MTS/N 23-350N93VBSky Blue Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887176N93VSLmh Industries Inc · Long Beach, CAS/N 126N93WEBoeing Employees Flying Assoc · Renton, WABuilt 1992 · S/N 659-92N93WKPiercy Ronald S · Moses Lake, WABuilt 1973 · S/N 643-74N93WPHbfc Inc · Tehachapi, CABuilt 1964 · S/N 28-20460N93WRDukic Slobodan · Jacksonville, FLBuilt 1977 · S/N 28-7890106N94000Champion Aircraft LLC · Valdosta, GAS/N 17258297
Back to AD 87-10-06 R1