OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N29TSBrady George K · Rose Hill, KSBuilt 1990 · S/N 1037-C49N29VMDragonfly Aviation LLC · Laredo, TXS/N 0368N29WXIngram Thomas C · Steele, ALBuilt 2025 · S/N 74419N29XCWunorse Openslae LLC · Dallas, TXBuilt 2017 · S/N CC19-0015N29YCAg One Aviation LLC · Villa Grove, ILS/N 1809068N29YDPerry David · Las Vegas, NVS/N 4456N29ZQ888wm LLC · Wilmington, DEBuilt 1986 · S/N 37N2ABBailey Richard T · Oregon City, ORBuilt 1960 · S/N 24-1941N2AEKnestel Tony Kevin · Naples, FLBuilt 1983 · S/N DICKSON-0001N2AGCentral Air Parts Inc · Staunton, ILBuilt 1972 · S/N 366-72N2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeBuilt 1981 · S/N R18201789N2AMFazio Peter A · Nokomis, FLBuilt 1977 · S/N 24-0156N2AWSpacecrafters Inc · Silver Springs, FLBuilt 1971 · S/N 17701692N2AXParks Dennis K · Hillsboro, ORBuilt 1994 · S/N 1319N2BNJensen Paul E · Exeter, NEBuilt 1973 · S/N 445-73N2BPMiami Clipper Aviation LLC · Cutler Bay, FLBuilt 1972 · S/N 17701783N2BUAndre George Maurice Trustee · Saint Louis, MOBuilt 1961 · S/N E3B-117N2BYMostello Andrew · Harvard, MABuilt 1977 · S/N 28R-7737129N2BZBosco74 LLC · Wilmington, DEBuilt 1975 · S/N 3227N2CZMagaw David · Sacramento, CABuilt 1975 · S/N 193HN2DARask Mark C · Becker, MNBuilt 1967 · S/N 28-23401N2DGAgostini Glenn · Tampa, FLBuilt 1964 · S/N 28-1526N2DLWhitver Jeremy · Ankeny, IABuilt 2005 · S/N 80583N2DPGreat Circle Flying Club Inc · Sandusky, OHBuilt 1973 · S/N 32-7340112N2DTBender Andrew J · Greenwood Lake, NYBuilt 1989 · S/N DM60-2N2DVLewis Paul A · Spring, TXBuilt 1960 · S/N 24-1679N2DWSquare One Enterprises Corp · Hot Springs, ARBuilt 1973 · S/N 28R-7335368N2DXLaw Coaching International · Irvine, CAS/N 61P07388063361N2EEMatthews Mark A · Independence, ORBuilt 1975 · S/N AA5B-0064N2EGKorver Kelvin M · Adams, NES/N 2N2FOrr Steven H · Murfreesboro, TNBuilt 1979 · S/N 61P06737963316N2FLCharvet Andre Bennett · Titusville, FLBuilt 1973 · S/N 332N2FNFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269910N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147N2GDGarland Gary · Oakhurst, OKBuilt 1979 · S/N AA5B1149N2GVKubecka Daniel P · Edna, TXBuilt 1946 · S/N 12-824N2GXFerrer Bryan A · Denver, COBuilt 2003 · S/N 0001N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382N2HDDelapp Douglas T · Placerville, CAS/N 82959N2HMRogers Zachary · Durham, NCBuilt 2000 · S/N 146N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342N2JDHauf Daniel Ray · Jack, ALS/N JM-1N2JGWetsu Enterprises Inc · Colorado Springs, COBuilt 1978 · S/N 403-78N2JLLane John T · Calico Rock, ARBuilt 2002 · S/N 20549N2JNPhillips Matthew L · Las Cruces, NMBuilt 1975 · S/N 1N2JUGlastar LLC · Ponte Vedra Beach, FLBuilt 2004 · S/N 0005247N2JVVan Grunsven Gerald B · Hillsboro, ORBuilt 1988 · S/N GV-4N2KAMorinaka Noble Jr · Nyssa, ORBuilt 1978 · S/N 18-7809116N2KFLivingston H Clark · Akron, ALBuilt 1968 · S/N 17700997N2KGLowe Samuel S III · Mary Esther, FLBuilt 1974 · S/N 17702073
Back to AD 87-10-06 R1