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.

N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126N33143Bascom Jon A Trustee · Tega Cay, SCBuilt 1975 · S/N 32-7500015N33147Johann Austin J · Richland Center, WIS/N 28-7525163N33148Hitchcock Lonnie G · Sparta, TNBuilt 1975 · S/N 28-7515322N33149Great Lakes Air Ventures LLC · Mason, MIBuilt 1975 · S/N 28-7515323N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127N33153Pathfinder Ff LLC · Dover, DES/N 28-7510040N33155Don George LLC · Orlando, FLBuilt 1975 · S/N 32-7540090N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165N33169Good James R H · Nevada City, CABuilt 1975 · S/N 28-7515326N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129N331ACTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1980 · S/N 28R-8018061N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514N331PHAppel Raymond Lee · Incline Village, NVBuilt 1977 · S/N 28-7710045N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401N3322WWilson Devin · Star, IDBuilt 1965 · S/N 32-156N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296N3324WThompson Mark D · West Chicago, ILBuilt 1965 · S/N 32-158N3325WGuzman Ronald Leonard · Salinas, CABuilt 1965 · S/N 32-160N3326MMcray Brett H · Sugar Land, TXBuilt 1977 · S/N 28R-7837111N3326WSair LLC · Natchitoches, LABuilt 1965 · S/N 32-161N3327MNearhoof Jeremy R · The Woodlands, TXBuilt 1977 · S/N 28R-7837112N3327PNewsome Charles Robert · Villa Rica, GABuilt 1988 · S/N 3213013N3327WBlacker James Darwin · Meridian, IDBuilt 1965 · S/N 32-162N3328MHidley Robert W · Oneida, TNBuilt 1977 · S/N 28R-7803165N3328QEastman John T · Winfield, KSBuilt 1977 · S/N 28-7725223N332BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881083N332CVYates Philip Arthur · Allen, TXBuilt 1996 · S/N 3246048N332KCAdams William M · Southlake, TXBuilt 2003 · S/N 3257332N332NDRapier Kenneth · Chicago, ILBuilt 1969 · S/N 28-26021N332PABird Acquisition LLC · Phoenix, AZS/N 2843515N33301Jensuz LLC · Agoura Hills, CABuilt 1975 · S/N 28R-7535130N33302Taffet Jay · New Orleans, LABuilt 1975 · S/N 32-7540092N33304Ellis Tom J · Chandler, AZBuilt 1975 · S/N 28-7525168N33307James Michael G · Dahlonega, GABuilt 1975 · S/N 32-7540093N3330RJph Incorporated · Kokomo, INBuilt 1970 · S/N 28-5659N33313Larson Laurinda P · Hubert, NCBuilt 1975 · S/N 28-7525170N33318Sudweeks Will · Overton, TXS/N 28-7525172N33319Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515328N3331QEvangelista Ronald · Castle Rock, COBuilt 1977 · S/N 28-7716148N3331REpik Industrial LLC · Terre Haute, INBuilt 1969 · S/N 28-5661N33321Lauher Donna · Wimberley, TXBuilt 1975 · S/N 28-7505133N33324Central Nebraska Spinal Surgery Center Pc · Kearney, NEBuilt 1975 · S/N 32-7500018
Back to AD 87-08-08 R3