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.

N8872PBlackburn Robert F · Georgetown, TXBuilt 1965 · S/N 24-4329N8873DWroe Daniel C · Denton, MDBuilt 1958 · S/N 22-6047N8873PTailwind Auditing Group LLC · Godley, TXBuilt 1965 · S/N 24-4330N8873WGarza Reynaldo E · Corpus Christi, TXS/N 28-10430N8874CPleasant Valley Aviation Inc · Bellefonte, PABuilt 1976 · S/N 28-7625135N8874JMelland Curtis B · Hazen, NDBuilt 1965 · S/N 28-2847N8874NFisher Tim A · Stockton, MDBuilt 1969 · S/N 28-25737N8874PWiebe Aron · Seminole, TXS/N 24-4331N8875DBishop Bill I · Cross Plains, TXBuilt 1958 · S/N 22-6049N8875NMcclendon Charles Dowel · Lynchburg, VABuilt 1969 · S/N 28-25738N8875WBryan Greg · Oelwein, IABuilt 1964 · S/N 28-10432N8876JDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2848N8876MLohman Curtis · Shelby, MIBuilt 1964 · S/N M-618N8876PWentworth Douglas G · Simpsonville, KYS/N 244333N8876VBlackburn Aviation Air LLC · Mesa, AZS/N 32-50N8876YComanche 76y LLC · Waynesboro, VAS/N 39-32N8877DSale Reported · Crystal, MNSale reportedBuilt 1958 · S/N 22-6051N8877EParrot Flying LLC · San Francisco, CABuilt 1976 · S/N 28-7625162N8877WAvery Aviation LLC · Picabo, IDBuilt 1964 · S/N 28-10434N8877YVanhook Orville Richard · Somerset, KYBuilt 1970 · S/N 39-34N8878DHamilton Clyde Leon · Forest, VABuilt 1958 · S/N 22-6052N8878NCampbell Carl F · Amherst, NHBuilt 1969 · S/N 28-25741N8878PHudson Albert Denning · Cornelius, NCBuilt 1965 · S/N 24-4337N8878WBallard Tim · Roseburg, ORS/N 28-10436N8879EFlickinger Charles P · Hermitage, PAS/N 28-7625163N8879JDaddona John M · Oakville, CTBuilt 1965 · S/N 28-2852N8879NBesheer Susan Anita · Palm Springs, CABuilt 1969 · S/N 28-25743N8879YWelstad Blaine L · Newburg, NDBuilt 1973 · S/N 18-7409027N887BCAustin Aviation LLC · Boise, IDBuilt 2023 · S/N 627-2023N887CCMr Dent Inc · Manheim, PABuilt 1978 · S/N GA7-0044N887KJCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2021 · S/N 28020025N8880NAnderson Aviation LLC · Bulverde, TXS/N 28-25744N8880YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-38N8881PIce Randall R · Pierre, SDBuilt 1965 · S/N 24-4340N8881VLien Ronald N · Gilford, NHS/N 17264240N8881WYellow Flyers Inc · Sioux Falls, SDBuilt 1964 · S/N 28-10440N8882ERandall Christopher D · Northridge, CABuilt 2008 · S/N 001N8882FCirrus Services Inc · Fargo, NDBuilt 1976 · S/N 28-7715294N8882VTop Aircraft Leasing LLC · Wilmington, DEBuilt 1974 · S/N 17264241N8882WFleet James Reginald Jr · Jacksonville, FLBuilt 1964 · S/N 28-10441N8883JRegistration Pending · Midlothian, TXRegistration pendingBuilt 1965 · S/N 28-2857N8883NWarner Alexander Douglas · Grand Rapids, MIBuilt 1969 · S/N 28-25749N8883PFlynn James Jay · Seneca, SCBuilt 1965 · S/N 24-4342N8883YYank N Bank LLC · Greeley, COBuilt 1970 · S/N 39-41N88847So-Do Holdings LLC · Monticello, GAS/N 32R-7680354N8884DJ C Aero LLC · Yelm, WABuilt 1958 · S/N 6354N8884NDubois Jerry · Oklahoma City, OKBuilt 1969 · S/N 28-25750N8884WFolse Eldred · North Las Vegas, NVBuilt 1964 · S/N 28-10444N8884YFlight Logistics LLC · Westerville, OHS/N 39-46N8885HHoughton Patrick K · Villa Rica, GABuilt 1961 · S/N 24-2577
Back to AD 87-10-06 R1