OpenAirDocs.org
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.

N46GBBuzel George Jr · Trumbull, CTBuilt 1998 · S/N BA-1N46HCCammack Howard D · Centennial, COBuilt 2001 · S/N 11236N46HSBlackburn Aviation Air LLC · Mesa, AZS/N 3430N46HYCelli Consulting LLC · Stockton, CABuilt 2004 · S/N 2264N46JCAdventures Air Express LLC · Malabar, FLBuilt 1997 · S/N 4636125N46JEHood Matthew G · Argyle, TXBuilt 2001 · S/N 24934N46JLWeaver Aviation LLC · Yucaipa, CABuilt 1975 · S/N 20-1169N46JRRay Homer A · Petrolia, CABuilt 2025 · S/N P38P-85P/86P-P136N46JTWorldwide Aviation Services LLC · Anderson, SCBuilt 2020 · S/N 001N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942N46KBBoatright Kyle W · Marietta, GABuilt 2001 · S/N 20343N46KJK-A Mirage LLC · Winnetka, ILBuilt 1996 · S/N 4636037N46KRPeterson Aviation LLC · Texarkana, TXS/N PO3884N46LULetourneau University · Longview, TXBuilt 2017 · S/N 4496415N46MJones Gregory D · Pueblo, COBuilt 1958 · S/N 24-411N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144N46MUMedic Choppers LLC · Springdale, ARS/N 253N46MYBeach Air LLC · Boynton Beach, FLBuilt 1975 · S/N 31-7552039N46PHarrison Donna J · Eau Claire, MIBuilt 1966 · S/N 24-4470N46PMMcmillan Michael J · Forsyth, GABuilt 1989 · S/N 4622081N46PNNuss Paul E Sr · Martinsburg, PABuilt 2013 · S/N PN-001N46PTT & K LLC · Bloomington, ILBuilt 1990 · S/N 4622108N46PWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 4636370N46RERocks Aero LLC · Carbondale, COBuilt 2000 · S/N 22600N46RRAma Aviation LLC · Dover, PABuilt 1987 · S/N 3206004N46RSHixson Steven D · Longview, WAS/N 6-7/8N46RVWithey Charles E · Hanson, MABuilt 1996 · S/N 20483N46SDPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8054040N46SEAddie-Air Inc · Bridgeport, TXBuilt 1992 · S/N 4622131N46SHMoghaddas Ali · Lake Sherwood, CABuilt 1987 · S/N 172N46TDRockstar Air LLC · Mcgregor, TXBuilt 1998 · S/N 4636177N46TFHowell George Ryan · Conway, NCBuilt 2018 · S/N 2546N46TJLile John G · Iowa Park, TXBuilt 1998 · S/N 23030N46UTVon Schmidt Gordon D · Waretown, NJBuilt 1973 · S/N 28R-7435068N46VCAltitude & Anchor LLC · Kalispell, MTS/N 3206N46VTPh Aviation Inc · Lewes, DEBuilt 2015 · S/N 40138N46WFFoy William N · Murfreesboro, TNS/N 32-971N46WHAbecca Corp · Jackson, MIBuilt 1993 · S/N 4622141N46WMMallia Karen W · Schenectady, NYBuilt 1997 · S/N 31N46WPPowers Phillip M · Cumberland Gap, TNS/N 60376N46YHDouglas Hiram P · Godley, TXBuilt 2025 · S/N 21026N46YMAircraft Partner Holdings Inc Trustee · BerlinBuilt 1992 · S/N 10026N4700SGiddyup Flyers LLC · Danville, CABuilt 1979 · S/N R18201388N4701LTrainor Jonathan P · Bridgewater, NJS/N 28-4014N4701SBailey Mark E · Owingsville, KYBuilt 1979 · S/N R18201389N47023Morey John Jack · Port Orange, FLBuilt 1977 · S/N 28-7890049N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074N4702HAbove All Others Consulting Inc · West Palm Beach, FLBuilt 1979 · S/N 24-0812N4703AStromberg Gary J · Medicine Lake, MTS/N 18-4918N4703LMaust Luke A · Accident, MDBuilt 1967 · S/N 28-4017
Back to AD 87-10-06 R1