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.

N81382Schear Brian · Costa Mesa, CABuilt 1977 · S/N AA5B0519N81384Royals Navy LLC · Lewes, DEBuilt 1977 · S/N AA5B0523N81388Byrne Jan · Greenwood, INBuilt 1977 · S/N AA5B0524N8138DAir Group Inc · Marietta, GABuilt 1958 · S/N 22-5629N8138EMorris John A · Phoenix, AZBuilt 1999 · S/N 146N8138HAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090178N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392N8138WSky Air Inc · Cedar Rapids, IABuilt 1965 · S/N 28-2251N8138YBelmont Aviation LLC · Port Saint Lucie, FLBuilt 1979 · S/N 28-8090180N8138ZAljundi Bassam S · Germantown, TNBuilt 1979 · S/N 28-8011051N81391Gibney Frank A · Colchester, VTS/N 1102N81398Mast Henry V · Dayton, TXBuilt 1995 · S/N 22327N8139EElliott Carl J · Fort Worth, TXRegistration revokedBuilt 1959 · S/N 1410N8139FStegall Ashley V · Daphne, ALBuilt 1979 · S/N 32R-8013043N8139NPerucca Douglas E · Wasilla, AKBuilt 1998 · S/N 3650N8139WHigh Five Flight Inc · Dawson, NEBuilt 1965 · S/N 28-2252N8139YBuchanan Jason A · Meridian, IDBuilt 1966 · S/N 30-1250N813BSutter Timothy C · Glennallen, AKS/N 6743N813BDD & D Airpark LLC · Anchorage, AKBuilt 2009 · S/N AF18183N813CNAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496251N813CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281249N813CTDoolley Flyers LLC · Harvard, MABuilt 1985 · S/N 28-8590080N813DCJ & J Aviation Holdings LLC · Dallas, TXBuilt 1999 · S/N 2843280N813DKRobinmith Aero Inc · Emerson, IABuilt 1980 · S/N 32R-8013103N813DLBoys Out Flying LLC · Stevens Point, WIBuilt 1977 · S/N 32R-7880003N813HCGeorgia Forestry Commission · Macon, GABuilt 2004 · S/N 18281460N813JMKohler James M · Newark, DES/N 32R13006N813JWComanche Air Inc · Tacoma, WAFirst renewal noticeBuilt 1972 · S/N 177RG0294N813KMSantopietro Paul · Dunnellon, FLBuilt 2001 · S/N 1321-2001N813PBunn Dennis E · Wilson, NCBuilt 1979 · S/N 28-7990589N813PKN813pk LLC · Columbia, MOBuilt 2001 · S/N 18280944N813SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881714N813SMWalicke Michael T · New Port Richey, FLBuilt 2002 · S/N 697EN813SSLake In The Hills Aviation LLC · Algonquin, ILBuilt 1974 · S/N 28-7415543N813THHolliday Terry C · Chugiak, AKBuilt 2019 · S/N HA-001N813WHOwens Waylon D · Pacific, WABuilt 2025 · S/N 83245N813WKTinney Michael · Piedmont, ALBuilt 1972 · S/N AA5-0106N81406Dorgate LLC · Charles City, IABuilt 1982 · S/N 28-8211028N8140DMckellar John T · Hamburg, NYBuilt 1957 · S/N 22-5631N8140PMcgee Edward · Pompano Beach, FLBuilt 1980 · S/N 28-8011081N8140QOlson Andrew John · Vail, AZBuilt 1980 · S/N 28-8011058N8141DCasper Glen · Garden City, KSS/N 22-5632N8141KKezele William A · Idaho Falls, IDBuilt 2022 · S/N 1083N8141REast Coast Foundation Specialists · Elkridge, MDBuilt 1982 · S/N 32R-8213032N8141WParham Randy L · Saint Charles, MOBuilt 1965 · S/N 28-2254N8141ZFbni Inc · Oakland, MDBuilt 1979 · S/N 28-8016240N8142Hostetler Craig L · Glendive, MTS/N FS-1N81425Pegasus Copters LLC · Makawao, HIBuilt 1945 · S/N 7AC-42N8142DMontague Mark W · Reno, NVBuilt 1957 · S/N 22-5633N8142EAbourezk Michael C · Rapid City, SDS/N 1413
Back to AD 87-10-06 R1