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.

N4071RHansen Lindsay Tucker · Las Vegas, NVBuilt 1968 · S/N 32-40381N40724Spirit Flyers Inc · Saint Louis, MOBuilt 1973 · S/N 28R-7435116N40726Miller Mark A · Covington, OHBuilt 1973 · S/N 28-7410047N4072WBradford Alan R Jr · Ridgecrest, CABuilt 1966 · S/N 32-40113N40735Magsig Joel S · Huntsville, ALBuilt 1973 · S/N 28-7425152N4073RLibby Stephen E · Lincoln, MEBuilt 1967 · S/N 32-40384N40740Veit John · Port Jefferson, NYBuilt 1973 · S/N 28-7405062N40746Flying Vikings Inc · Hayward, CAS/N 28R-7435119N40747Cherokee Flyers LLC · Austin, TXS/N 32-7440058N40752Jourdan Frank E · Overland Park, KSBuilt 1973 · S/N 28-7425155N40755Gebus Jaroslaw · Fort Myers, FLS/N 28-7415079N40758Charlie Six LLC · Mesa, AZBuilt 1973 · S/N 32-7400022N4075RCoastal Airways LLC · Dover, DEBuilt 1968 · S/N 32-40387N40767Bart Steven C · Highland, CABuilt 1973 · S/N 28-7405064N40768Trescone Dennis M · Rochester, MIBuilt 1973 · S/N 28R-7435122N4076RTwk Air LLC · Morgantown, PABuilt 1968 · S/N 32-40389N40776Third Coast Aircraft LLC · Mobile, ALBuilt 1973 · S/N 28-7425163N4077RMccollum Aviation Inc · Friendswood, TXS/N 32-40390N40784High Flying Club Inc · Fort Wayne, INBuilt 1973 · S/N 32-7440060N40787Henrich Perrin · Northridge, CABuilt 1973 · S/N 28-7425164N4078RBrehmer Family Airplane LLC · Knoxville, TNBuilt 1967 · S/N 32-40392N40798Hovnanyan Ari · Woodland Hills, CABuilt 1973 · S/N 28-7415087N407FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020207N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545N407TLBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 28R-7135013N40801Island View Flying Club · Goleta, CAS/N 28-7410049N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169N4080WLance & Company LLC-S · Uniondale, INBuilt 1966 · S/N 32-40125N40810Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7415088N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068N4081SScheerer Martin · Edina, MNBuilt 1974 · S/N 28R-7435130N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173N40829Shively Ray F · Turtlepoint, PABuilt 1973 · S/N 28-7415090N4082RMid-Life Crisis Aviation LLC · Renton, WABuilt 1968 · S/N 32-40398N40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeBuilt 1973 · S/N 28-7415091N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176N40838Andrews Mark F · Jacksonville, FLBuilt 1973 · S/N 28-7415093N4083QStroemsvik Kristian · Strasburg, VAS/N 28-7725235N40842Avz Aviation Inc · Knoxville, TNBuilt 1973 · S/N 28-7415094N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070N4084RLand Aerial Services LLC · Conway, ARBuilt 1967 · S/N 32-40401N4084WGraham Jessami T · Walsh, COBuilt 1966 · S/N 32-40133N40850Mitchell Timothy · Enterprise, ALBuilt 1973 · S/N 28-7425178N40852Air Performance LLC · Kalispell, MTBuilt 1973 · S/N 28R-7435134N40856Griggs Gerald A · Blairsville, GABuilt 1973 · S/N 28-7425180N40857Muller-Levan Christina J · Kempton, PABuilt 1973 · S/N 28-7415099N40858Dicey Aviation LLC · Somerset, KYBuilt 1973 · S/N 28-7415102N4085QWarrior 85q LLC · Vero Beach, FLS/N 28-7716170N4085RWojdac David E · Mosinee, WIS/N 32-40402
Back to AD 87-08-08 R3