OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N6291WBrenton Perry · Crestview, FLBuilt 1964 · S/N 28-20335N6292WAmerican Aviator LLC · Arlington, TXBuilt 1964 · S/N 28-20336N6293JClear Horizon Holdings LLC · Cheyenne, WYBuilt 1976 · S/N 28-7690395N6293WFisher Russell D · Vacaville, CABuilt 1964 · S/N 28-20338N6294CB A R C Asset Management LLC · Boynton Beach, FLBuilt 1978 · S/N 28-7890358N6295WJ Delgado Aviation LLC · Tulsa, OKBuilt 1964 · S/N 28-20340N6296WBarthell Frederick · Sun City West, AZS/N 28-20341N6297JYale Aviation Inc · New Haven, CTBuilt 1976 · S/N 28-7690394N6297WDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1964 · S/N 28-20342N6298JPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 28R-7635334N629CDrc Aviation Of Stuart LLC · Palm City, FLBuilt 2003 · S/N 3257331N629CGC-4 Aviation LLC · Fruitland Park, FLFirst renewal noticeBuilt 1981 · S/N 32-8106094N629FCDoherty Paul A · Van Buren, ARBuilt 1979 · S/N 32-7940182N629FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842132N629NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881148N629NFSunstarr Aviation LLC · Fond Du Lac, WIS/N 28-7790431N62BPPecan Aviation LLC · Granbury, TXBuilt 1980 · S/N 32-8024041N62DJZig Zag Inc · Wilmington, DES/N 32-7640062N62GWGoshen Wings Inc · Bristol, INBuilt 1980 · S/N 32R-8129030N62LPMagic City Aviators LLC · Hoover, ALBuilt 1977 · S/N 32R-7780375N62MDRegistration Pending · Deland, FLRegistration pendingBuilt 1969 · S/N 28R-31073N62QNottingham Gatz D · Paris, TXBuilt 1972 · S/N 28-7210011N62RMEmployment Services Inc · Virginia Beach, VABuilt 1962 · S/N 28-352N62SBLee Robert A · Hartford, WIBuilt 1981 · S/N 28-8111071N6300JWoltman Roger · Cherokee, IABuilt 1968 · S/N 28-4709N6300MShortfin Holdings LLC · Seneca, SCBuilt 1974 · S/N 32-7440141N6300YSullivan Mark F · Cocoa Beach, FLFirst renewal noticeBuilt 1974 · S/N 32-7540044N6301CMustang Aviation LLC · Orleans, NEBuilt 1978 · S/N 28-7890359N6301JMorais Antonio L · Greenacres, WABuilt 1968 · S/N 28-4712N6301WKap Title Inc · Tucker, GABuilt 1964 · S/N 28-20344N6302JFlying Three Inc · Milton, KSBuilt 1968 · S/N 28-4713N6302RAiken Joshua · Plano, TXBuilt 1966 · S/N 28-21467N6303RDorris Chris DBA · Mount Juliet, TNFirst renewal noticeBuilt 1966 · S/N 28-21468N6304CHarben LLC · Albemarle, NCBuilt 1978 · S/N 28R-7837155N6304JFlying Colts Inc · Rew, PABuilt 1968 · S/N 28-4715N6304RBastida William M · San Rafael, CABuilt 1966 · S/N 28-21469N6306JCampbell Christopher J · Enterprise, ALBuilt 1968 · S/N 28-4717N6306WNovotny Warren · Wadsworth, OHS/N 28-20350N6307WJohnson Bradley M · Belgrade, MTS/N 28-20351N6308DBjornoos Robert · Cambridge, MNBuilt 1974 · S/N 28-7510023N6309JLopez Josue Ismael · Foothill Ranch, CAS/N 28-4721N6309RAerowolfe Aircraft Services LLC · Spokane, WABuilt 1966 · S/N 28-21475N630BJJones Robert M · Brooksville, FLBuilt 1969 · S/N 28-26111N630HCDgsz Aero Inc · Bear, DEBuilt 1980 · S/N 28-8090268N630KTLetourneau Duane R · Oconto, WIBuilt 2000 · S/N 28-43397N630RJHovan Robert G · Port Orange, FLBuilt 1979 · S/N 28-7916503N6310RCcb Warriors LLC · Lawrence, KSBuilt 1966 · S/N 28-21476N6312CLibra Air Inc · Las Vegas, NVBuilt 1978 · S/N 28-7816405N6313CShouling & Philip Enterprise · Lancaster, CABuilt 1978 · S/N 28-7816406N6313WFlight Plan LLC · Friendswood, TXBuilt 1964 · S/N 28-20359
Back to AD 87-08-08 R3