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.

N57472Kutztown Aviation Service Inc · Germansville, PABuilt 1973 · S/N 512-73N57473Duncan Michael E · Auburn, CABuilt 1973 · S/N 378-73N57476Boucher Gregg D · Hinsdale, MTBuilt 1973 · S/N 516-73N5747DMcmillian Roger L · Camdenton, MOBuilt 1956 · S/N 22-4447N5747FMsol Air LLC · Lakeland, FLBuilt 1968 · S/N 28-25048N57488Rocky 80 Inc · Ethridge, MTBuilt 1973 · S/N 521-73N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823N57492Trimble Tanner J · Blue Rapids, KSBuilt 1984 · S/N 24-1455N5749WDch Aviation LLC · Owasso, OKBuilt 1963 · S/N 28-1467N5749XFlash Aviation LLC · Elkton, MDBuilt 1984 · S/N 24-1454N574AKFirey Charles R · Anchorage, AKBuilt 2015 · S/N 001N574ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496199N574BFKrusemark Emma A · Pender, NES/N 28-25047N574CLMaier Ludwig Peter · Port Orange, FLS/N 574N574CMMarshall Aviation Services Inc · Elkhart, INBuilt 2008 · S/N 99N574CZSiu Bernard K · Diamond Bar, CABuilt 2016 · S/N 1N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574DGSmith Bruce Martin Trustee · Spirit Lake, IDBuilt 2003 · S/N 777N574FLDynamic Aviators LLC · San Angelo, TXS/N 28-7125421N574HBIngram Grant Leigh · Hurricane, UTBuilt 2021 · S/N 4134CN574HFKilo Romeo LLC · Anchorage, AKBuilt 2001 · S/N T20608308N574KBBrooks Flyers LLC · Willow, AKBuilt 2021 · S/N 22046CN574KRPhoenix Rising Aviation Inc · Bartlesville, OKS/N 22-5273N574LBThoft Matthew M · Wasilla, AKBuilt 1977 · S/N 18-7709109N574MMMyers Benny R · Wasilla, AKBuilt 2023 · S/N 100N574PRSoto Angel L · Las Piedras, PRBuilt 1965 · S/N 32-241N574RHRob Holland Ultimate Airshows LLC · Coushatta, LABuilt 2021 · S/N MX2-002N574TMJohnson Tristan O · Pensacola, FLBuilt 1974 · S/N 32-7540019N57503Martin William A · Nashville, TNBuilt 1973 · S/N 95-73N57505Archipelago Group Llcc · Alexandria, VAS/N 267-73N5750MStites Holdings LLC · Seattle, WAS/N 24-1457N5750PRoberts Donald W · Flower Mound, TXBuilt 1959 · S/N 24-825N5750QMelnyk Richard V · Uniontown, PABuilt 1965 · S/N 3077N57515Peterson Dean · Gothenburg, NEBuilt 1973 · S/N 380-73N57517Du Aircraft Leasing · Green Bay, WIS/N 526-73N57519L & L Flying Inc · Glen Allan, MSS/N 532-73N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826N57522Baker Brad L · Salcha, AKBuilt 1973 · S/N 534-73N5752QJackson John E · Oak Harbor, WABuilt 1965 · S/N 3078N5752URiggin Flight Service · Madison, SDS/N 28-26575N5752YShackelford John S Jr · Roanoke, TXS/N 27-2877N57532N57532 LLC · Wasilla, AKS/N 18-7809089N57534Sale Reported · Drake, NDSale reported, pending cancellationBuilt 1978 · S/N 18-7809090N5753FRauch Jack · San Rafael, CABuilt 1968 · S/N 28-25056N5753WRegistration Pending · Royse City, TXRegistration pendingS/N 28-1490N5753ZFereday Richard R · Mccall, IDBuilt 1963 · S/N 18-8026N5754DRocca John · Box Elder, SDS/N 22-4454N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5754FStorm Joseph K · Enumclaw, WABuilt 1968 · S/N 28-25057
Back to AD 87-10-06 R1