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.

N47023Morey John Jack · Port Orange, FLBuilt 1977 · S/N 28-7890049N4703LMaust Luke A · Accident, MDBuilt 1967 · S/N 28-4017N4705LHorton Kelly · Hollis, OKBuilt 1967 · S/N 28-4019N4706LKings Heir Inc · Kent, WABuilt 1967 · S/N 28-4026N4708LAlexander Nicholas R · Oak Hill, OHBuilt 1967 · S/N 28-4027N4709LJohannsen Michael R · Allen, TXBuilt 1967 · S/N 28-4028N470AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843742N470FLBaker Brian K · Dayton, OHBuilt 1971 · S/N 28-7125271N470SEZ Air LLC · Houston, TXBuilt 2007 · S/N 3257470N4710LStuhmer Samuel K · Central City, NEBuilt 1967 · S/N 28-4029N4711YAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28R-7335424N4713CTron Aviation LLC · Orlando, FLS/N 28-7225574N4713LHutson Richard M · Trenton, SCBuilt 1967 · S/N 28-4032N4715LSmith Bryan E · Mt Juliet, TNBuilt 1967 · S/N 28-4035N4716LLong Steven M · Baton Rouge, LABuilt 1967 · S/N 28-4036N4718LSnt Aviation LLC · Laurel, MSBuilt 1967 · S/N 28-4038N4719LMinderman David J · Westlake, OHBuilt 1967 · S/N 28-4039N471AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843743N471DLSutton Douglas A · Paola, KSBuilt 1964 · S/N 28-10384N471HCHinds Community College · Raymond, MSBuilt 2024 · S/N 28020199N471TAAtp Taa LLC · Wilmington, DES/N 2881313N471VVlieg Roger W · Marianna, FLBuilt 1966 · S/N 28-10844N4721LLee Christopher S Sr · Quinton, VABuilt 1967 · S/N 28-4043N47225Aviation Partners Inc · Carson City, NVBuilt 1977 · S/N 28-7890050N47227N47227 Inc · Hobe Sound, FLBuilt 1977 · S/N 28R-7737158N47228Sg Holdings LLC · Grand Mound, IABuilt 1977 · S/N 28R-7703354N47232Lensis Thomas M · Wilmington, NCBuilt 1977 · S/N 32R-7880001N4726SN4726s LLC · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-1165N4727LTeton Anesthesia Ltd · Batesville, ARS/N 28-4051N4727SCarlin Delbert J · Blanchard, OKBuilt 1969 · S/N 32-1166N4728SSam Aviation Corp · Millstadt, ILS/N 32-1167N4729LCollinson Roger A · Concord, NCBuilt 1967 · S/N 28-4053N4729SKitko Paul D · Cincinnati, OHBuilt 1969 · S/N 32-1170N472DDMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881576N472DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010072N472RPWsic LLC · Crosbyton, TXBuilt 1979 · S/N 32-7940091N472TAAtp Taa LLC · Wilmington, DES/N 2881314N4730FDavison Carl A · Snohomish, WABuilt 1976 · S/N 28-7790058N4730LMorris Robert W Jr · Owasso, OKS/N 28-4055N4731FKaland Gary D Trustee · El Cajon, CABuilt 1976 · S/N 28-7790059N47321Griffith Aviation Inc · Griffith, INBuilt 1977 · S/N 28-7816057N47323Danaha Jerry E · Diamond Bar, CABuilt 1977 · S/N 28-7816058N47326Maury David · Winter Garden, FLS/N 28-7890052N4732LRaven Gang Flyers Corp · Wilmington, DEBuilt 1967 · S/N 28-4058N47337Beatty William Keith · Lakeland, FLBuilt 1977 · S/N 28R-7737159N47339Grider Aviation Inc · Indianapolis, INS/N 28R-7703357N47342Buckley Air LLC · Plymouth, MABuilt 1977 · S/N 32R-7880002N47349Fox Two LLC · Camino, CAS/N 28-7816060N4734LForsgren Lyle M · Oshkosh, WIBuilt 1967 · S/N 28-4060N47350Evanson Mark A · Wharton, TXBuilt 1977 · S/N 28-7816061
Back to AD 87-08-08 R3