OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N2500PLasche James R Jr · Weatherford, TXBuilt 1955 · S/N 22-2861N2500UFrisbie Anthony G · Dallas, TXBuilt 1964 · S/N 28-1873N2500VDarnell Fred A Jr · Charlotte, NCBuilt 2008 · S/N 066SRN2500ZGuldi James E · Port Orange, FLBuilt 1977 · S/N 991-77N2501GN2501g LLC · Columbia, CABuilt 1967 · S/N 112N2501MSchwietz Thomas E Jr · Strasburg, VAS/N 27-7954068N2501NMarch Peter J · Peotone, ILS/N 900N2501RNelson Curtis J · Altoona, IABuilt 1969 · S/N 28-5637N2501WSolari Peter L · Lebanon, CTBuilt 1973 · S/N MC-155N2502ZByrne Gary W DBA · Georgetown, INBuilt 1977 · S/N 328-77N25030Eller Walton G III · Katy, TXBuilt 1985 · S/N 28-8590081N2503DAlnico Aviation LLC · Lafayette, INS/N 864N2503ZAviation Financial Corp · Torrance, CABuilt 1977 · S/N 613-77N2504BHatz Aeronautics LLC · Pompano Beach, FLBuilt 1989 · S/N 862N2504WBade Russell E · Carlsbad, CAS/N 22839N25055Dakota N25055 LLC · Irvine, CABuilt 1985 · S/N 28-8511018N25059West William Douglas · Newton, NCS/N 936N2505FAcme Anvil LLC · Parker, COBuilt 1965 · S/N 127N2505RTcheutchua Romeo J · Olathe, KSBuilt 1969 · S/N 28-5638N2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeBuilt 1977 · S/N 330-77N2506WHeiss William R · Watkins, COS/N MC-165N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77N2507Wagar Dennis Murphy · Marion, MTBuilt 2022 · S/N 5330N2507KLabonte Stephen M · Gilford, NHBuilt 1968 · S/N 217N2507QGift Arthur D Trustee · Wanatah, INBuilt 1977 · S/N 32-7740050N2507TCoscarelli Guillrtmo H · Wailuku, HIS/N 914N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190N2507ZZawada John R · Wht Sphr Spgs, MTBuilt 1999 · S/N 55N2508WBas Part Sales LLC · Greeley, COS/N MC-166N25096Green Air LLC · Novato, CAS/N 961N2509DLong Joel A · Clinton, MOBuilt 2000 · S/N 22501N2509PAubort Eric Y · Laguna Hills, CABuilt 1955 · S/N 22-2870N2509RStovall Shane R · Salado, TXBuilt 1969 · S/N 28-5639N2509XOrsippus Management LLC · El Dorado Hills, CAS/N 951N2509ZKovach Kim A · Ocala, FLS/N 333-77N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045N250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1971 · S/N 25-5425N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082N250BTHeart Gate Enterprises LLC · Pittsburgh, PABuilt 2002 · S/N 4636334N250CCAerodynamics Worldwide Inc · Wilmington, DEBuilt 1960 · S/N 24-1931N250CHSorrell Jeffrey R · Winter Haven, FLS/N 250N250DJRhoades James H · Pleasanton, CABuilt 1980 · S/N 0003-80N250DSLanger Paul Hubert · Gainesville, TXBuilt 1996 · S/N 250N250ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608250N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148N250FMParagon Airplane Leasng Co · Fort Myers, FLBuilt 2022 · S/N 28020100N250GTComanche Golf Tango LLC · Clifton, VAS/N 24-2496N250HCCornerstone Air Holdings LLC · Fort Scott, KSBuilt 1977 · S/N 32R-7880037N250JBGuy Jeffrey · Centerburg, OHBuilt 1981 · S/N A-109N250JFSnapp Michael D · Portland, ORBuilt 1997 · S/N 644-320-389 FB
Back to AD 87-10-06 R1