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.

N4984JBluewater Airmotive Corp · Wilmington, DEBuilt 1968 · S/N 28R-30738N4984RGingrich Fredric D II · Indianapolis, INBuilt 1977 · S/N 28-7890047N4984SLinair LLC · Lewes, DEBuilt 1970 · S/N 28R-35704N4984TBoggs Investments Air Div LLC · Fredericksburg, VABuilt 1972 · S/N 28-7225302N4985JEri-Aero Land Partners LLC · Flower Mound, TXBuilt 1968 · S/N 28R-30739N4985TPope Donald R · Enid, OKBuilt 1972 · S/N 28R-7235167N4986JMcelhiney Lance V · Harker Heights, TXBuilt 1968 · S/N 28R-30740N4986LFarrah Gabriel E · Avon, CTBuilt 1967 · S/N 28-4361N4987JFulco Jason E · Frisco, TXS/N 28R-30742N49886Boon Bradley A · Greenwood, WIBuilt 1962 · S/N 28-1010N4988LAnson Flyers Club Inc · Wadesboro, NCBuilt 1967 · S/N 28-4362N4989JEastern Florida State College · Cocoa, FLBuilt 1968 · S/N 28R-30744N498CCShephard Russell Steven · Gallatin, TNBuilt 1976 · S/N 28R-7635447N498FLOneforty LLC · Dover, DEBuilt 1971 · S/N 28-7125315N498HPSafe Flight Ops LLC · Venetia, PABuilt 1998 · S/N 3246121N498MALake Air Express LLC · Bettendorf, IABuilt 1998 · S/N 3246098N4990JEstes Aviation LLC · Vicksburg, MSBuilt 1968 · S/N 28R-30746N4990LCc Aero Services LLC · Bullard, TXBuilt 1967 · S/N 28-4364N4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842230N4991LStrickland Sterling S · Sammamish, WABuilt 1967 · S/N 28-4381N4992JBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 28R-30748N4992LGrove City Aviation LLC · Mercer, PABuilt 1967 · S/N 28-4365N4993LEagerton Aviation LLC · Florence, SCS/N 28-4366N4994JCrowe Justin L · Tompkinsville, KYS/N 28R-30750N4994SSmith Thomas C · Norfolk, VABuilt 1970 · S/N 28R-35719N4995FSkorina Frank K · Walla Walla, WABuilt 1976 · S/N 28-7725040N4995SNova Aero LLC · Ontario, ORBuilt 1970 · S/N 28R-35720N4996JLee Matthew · Magnolia, TXBuilt 1968 · S/N 28R-30752N4996LConverse Alan W · Garfield, KSBuilt 1967 · S/N 28-4369N4996SChabrian Jerry W · Daytona Beach, FLBuilt 1970 · S/N 28R-35721N4998GOdenbach Eric J · Eureka, SDBuilt 1974 · S/N 28-7425218N4999FHarrington Jennifer L · Minneapolis, MNBuilt 1976 · S/N 28-7715091N4999LKnox Mark M · Thornton, PABuilt 1967 · S/N 28-4371N4999SStaples Chad V · Efland, NCBuilt 1970 · S/N 28R-35724N499AT And B Aviation LLC · Oregon City, ORBuilt 1979 · S/N 28R-7931091N499FCFoxtrot Charlie Aviation LLC · Charlotte, NCBuilt 1976 · S/N 32R-7780076N499FLSchrock Derrick L · Jesup, GABuilt 1971 · S/N 28-7125316N499TGCrest Aviation LLC · Broomfield, COS/N 28-7425318N49HDSasnak Inc · Wichita, KSS/N 28R-7803104N49KMAvance Aviaiton LLC · Burlington, MABuilt 1969 · S/N 28-5729N49LBOwen Walter M · Arlington, TNBuilt 1976 · S/N 32R-7680481N49PTWright Wrench Aviation LLC · Cedar City, UTBuilt 1997 · S/N 2843094N49SFBcr Aviation LLC · Chantilly, VABuilt 1978 · S/N 32-7940019N4BKAccurti LLC · Deerfield Beach, FLBuilt 1967 · S/N 28-4052N4BQHann Robert Scott III · Gilbert, AZBuilt 1967 · S/N 28-4474N4BRRoberts Boyd · Celeste, TXBuilt 1973 · S/N 28R-7335423N4GCJenner Enterprises LLC · Partlow, VAS/N 28-21358N4JGCrews Rory C · Athens, ALBuilt 1972 · S/N 28-7205281N4SGCp Aero LLC · Missoula, MTBuilt 2002 · S/N 3257282N4THIm Plane Crazy Ltd · Wilmington, DEBuilt 1978 · S/N 28-7890499
Back to AD 87-08-08 R3