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.

N860SASaint Clair Flight Academy Inc · Richmond, MIBuilt 2001 · S/N 172S8860N860SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881743N860SPRegistered aircraftBuilt 1999 · S/N 172S8131N860TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842417N860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020195N8610NSkipper Donald J · Huntersville, NCBuilt 1971 · S/N 28R-7135131N8610PTapert Warren F · Lenox, MIBuilt 1964 · S/N 24-4063N8610RTener Dean R · Lisbon, OHBuilt 2023 · S/N 91918N8611VAlbright Harold R · Dubois, WYS/N 155-75N8611WSheppard Travis · Terrebonne, ORBuilt 1963 · S/N 28-10127N8611YCragg Gordon E · Georgetown, TXBuilt 1968 · S/N 30-1751N8612DPerry Leonard M · Soldotna, AKBuilt 1957 · S/N 22-5812N8612PFranz James T · Glendale, AZBuilt 1964 · S/N 24-4064N8613DPerry Kenneth V · Katy, TXS/N 22-5811N8613VBoley Trevor T · Palmer, AKS/N 804-75N8614NFarmers Bank Of Northern Missouri Na · Unionville, MOBuilt 1970 · S/N 32-7140006N8614PLee Patrick J Jr · Lindstrom, MNBuilt 1964 · S/N 24-4065N8614WRegistration Pending · Grand Junction, CORegistration pendingBuilt 1963 · S/N 28-10056N8614YD&D Maintenance LLC · Etna Green, INBuilt 1968 · S/N 30-1754N8615VCitabria N8615v LLC · Westminster, COBuilt 1975 · S/N 504-75N8615WJefferson Community & Technical College Foundation · Louisville, KYS/N 28-10060N8615YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1968 · S/N 30-1755N8616DFrancis Harvey B · Key West, FLS/N 22-5815N8616VPittman Michael · Goodridge, MNS/N 808-75N8616WKlopsch Steven J · Colbert, WABuilt 1966 · S/N 28-10793N8617DGrisham Michael H · Paulden, AZBuilt 1957 · S/N 22-5820N8617HToutant Roland J · Woodstock, CTBuilt 1981 · S/N 701N8617PFrisbie Kevin R · Fairfield, IABuilt 1964 · S/N 24-4067N8617WHacker George A · Renton, WABuilt 1963 · S/N 28-10131N8617YBurton David A · Pepperell, MABuilt 1981 · S/N 1500N86183J L Air LLC · Wilmington, DEBuilt 1981 · S/N 1506N8618LLatimer Lawrence A · Vernon, TXBuilt 1969 · S/N 25-5047N8618YGroup Aire II · Manitowoc, WIBuilt 1968 · S/N 30-1758N86198Styer David B · Pendleton, ORBuilt 1981 · S/N 521-2N8619ACowboy Up Aviation LLC · Frenchglen, ORBuilt 1981 · S/N 705N8619DBenton Mark H · Sussex, WIBuilt 1957 · S/N 22-5822N8619EHogan Daniel L · Chapel Hill, NCBuilt 1976 · S/N 28-7625143N8619LAerial Banners Inc · Pembroke Pines, FLBuilt 1969 · S/N 25-5049N8619PStewart Mark A · Mccall, IDBuilt 1964 · S/N 24-4068N8619VPlane Folks LLC · Tucson, AZBuilt 1975 · S/N 809-75N8619YNuse Aviation LLC · Hollidaysburg, PABuilt 1968 · S/N 30-1759N861ACGuglietta Glenn W · Payson, AZBuilt 2000 · S/N 861-2000N861APKlein Edwin Andrew Bell · Grass Valley, CABuilt 1957 · S/N 22-4769N861BABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280101N861CDHansell David A · Windsor, COBuilt 2024 · S/N 42258N861CHPope James D · Lewiston, IDBuilt 2000 · S/N 3156N861MMGiordano Matthew J Jr · Wilmington, DEBuilt 2012 · S/N 81834N861PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843945N861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 18281438N861VLVieques Air Link Inc · San Juan, PRBuilt 1984 · S/N 2155
Back to AD 87-10-06 R1