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.

N681JBJuliet Bravo Aviation LLC · South Padre Island, TXBuilt 1980 · S/N R18201672N681LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 2006 · S/N 11211N681LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881231N681MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8203N681TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881881N6820BAnderas Per R · Green Bay, WIS/N 22-4116N6820LFoode Frank J · Cordova, AKBuilt 1974 · S/N 18-7409104N6820NLopez George P · Sacramento, CAS/N 680107N6820VMwjf Air LLC · Barrington, NHBuilt 1971 · S/N 22-0006N6821PComanche Logistics LLC · Lake City, FLBuilt 1960 · S/N 24-1954N6821URed Baron LLC · Middletown, DES/N 2536N6821VMiller Titan G · Tehachapi, CAS/N 20-0003N6822LDavis Robert E · Wasilla, AKBuilt 1974 · S/N 18-7409105N6822NBianchi Marion A · Goose Creek, SCBuilt 1968 · S/N 680116N6822VDk Aero LLC · Greenville, SCBuilt 1971 · S/N 22-0007N6822WAjf Enterprises LLC · Des Moines, IAS/N 28-20960N6823HClay Howard C II · San Francisco, CAS/N 17265596N6823NTawil Anan · Salem, ORBuilt 1968 · S/N 680108N6823PKoopmans Caleb · Bridgewater, SDBuilt 1960 · S/N 24-1956N6823UClark Bradley K · Ypsilanti, MIBuilt 1963 · S/N 182N6823WThomas Kevin A · Selbyville, DEBuilt 1965 · S/N 28-20961N6823YWingsleasing LLC · Wichita, KSBuilt 1969 · S/N 27-4163N6824JMorrison Justin Gregory · Houston, TXBuilt 1976 · S/N 28-7625243N6824PAtlas Equipment LLC · Casper, WYBuilt 1960 · S/N 24-1957N6824ULefevre Duane S · Grover, WYS/N 183N6824WRoberts John R Jr · Homestead, FLBuilt 1965 · S/N 28-20962N6825BAlborn Wyatt A · Homer, AKBuilt 1956 · S/N 22-4121N6825JByrd Mark L · Belpre, OHBuilt 1976 · S/N 28-7615368N6825NWilliams Jerry Riley Sr · Wabbaseka, ARS/N 680118N6825URipley Holdings Ltd · Santa Monica, CABuilt 1963 · S/N 184N6825VRegistered aircraftBuilt 1971 · S/N 21-0008N6825YDenton J Frederick · Hutchinson Island, FLS/N 27-4165N6826NInterwest Management · Angwin, CABuilt 1968 · S/N 680109N6826WMartinak Charles J · Rehrersburg, PABuilt 1965 · S/N 28-20966N6827ULeong Thomas M · El Monte, CABuilt 1963 · S/N 186N6827VAerostar Air LLC · Kilgore, TXBuilt 1971 · S/N 20-0005N6827WShort Final Aviation LLC · Branson, MOBuilt 1965 · S/N 28-20967N6828BVantreese Jason B · Quanah, TXS/N 22-4125N6828JKdrd Holdings LLC · Texas City, TXBuilt 1976 · S/N 28R-7635337N6828NFisher Scott · Searcy, ARBuilt 1968 · S/N 680120N6828VEvanson Mark A · Wharton, TXBuilt 1971 · S/N 21-0009N6828WOleary David L · Framingham, MABuilt 1965 · S/N 28-20968N6829NWilliams Mark J · Ojai, CAS/N 680110N6829VE N Entertainment Inc · El Dorado Hills, CABuilt 1971 · S/N 22-0012N682ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010082N682ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496285N682FGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1969 · S/N 30-1955N682JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020082N682LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881245N682MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8204
Back to AD 87-10-06 R1