OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N591RVSims David L · Mc Alpin, FLBuilt 2025 · S/N 93270N591VUVu Anh · Fredericksburg, VABuilt 2006 · S/N 40141-1AVN5920DBates Matthew T · Springfield, VABuilt 1956 · S/N 22-4582N5920QKellogg Annabelle S · Cumming, GABuilt 1965 · S/N 825N5920WSynergy Aviation LLC · Greer, SCBuilt 1966 · S/N 28-3223N5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSBuilt 1965 · S/N 27-3077N5921HHoehne Michael G · Vienna, VABuilt 1949 · S/N 16-542N5921PFiscus Ryan K · Burleson, TXBuilt 2022 · S/N 059N5921WStearns Edwin Ben Jr · Eloy, AZS/N 28-3227N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963N5922FNeel Aviation LLC · Lakeland, FLBuilt 1976 · S/N 28-7715158N5922PWiseman Transport LLC · Henderson, TXBuilt 1959 · S/N 24-1009N5922UPagan Jose A · Kokomo, INBuilt 1970 · S/N 28-26408N5922VHopper David · Mcgregor, TXBuilt 1977 · S/N 32R-7780378N5922YUltimate Air Parts LLC · Strasburg, VABuilt 1965 · S/N 27-3080N5923WPremier Pilots LLC · Herriman, UTBuilt 1966 · S/N 28-3246N5924FN5924f LLC · Cocoa, FLS/N 28-7715159N5924PPope Mark I · Arco, IDBuilt 1959 · S/N 24-1011N5924QWright Andrew · Sacramento, CABuilt 1965 · S/N 827N5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1970 · S/N 28-26815N5924WPribbenow Dennis A · Payson, AZBuilt 1966 · S/N 28-3273N5926BAddington Ralph P · Orlando, FLS/N 90712N5926DToste Greg · Newcastle, CABuilt 1956 · S/N 22-4589N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143N5926UIron Flyer Of Cuzamil LLC · Lewes, DES/N 28-26739N5926WLeonard Jeffrey A · Bakersfield, CABuilt 1966 · S/N 28-3311N5927PSchlup John R · Booneville, ARBuilt 1959 · S/N 24-1015N5927WKochling Christopher · Houston, TXBuilt 1966 · S/N 28-3331N5928EGace Flying Club Inc · Ronkonkoma, NYBuilt 1978 · S/N 17271964N5928JParsons Royson A · Atascadero, CABuilt 1971 · S/N A1500228N5928QSchmidt Tyren A · Albertville, MNBuilt 1965 · S/N 829N5928WRegistered aircraftN-number assigned, not yet registeredS/N 28-3367N5929WEdwards Allan · Leesburg, VABuilt 1966 · S/N 28-3368N592CJAims Community College · Greeley, COBuilt 2019 · S/N 2881183N592DJFandango Ranch Operating Co Inc · Anacortes, WAS/N 592N592FLGrey Rose Air LLC · Edenton, NCBuilt 1971 · S/N 28-7125455N592JSStraut James M · Upper Saddle River, NJS/N 18281041N592KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843931N592NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496634N592RSProbst Danny R · Nokomis, ILBuilt 2003 · S/N 90400N592SCN592sc LLC · Inola, OKS/N 3100N592ZHorton Michael D · Vernal, UTBuilt 1994 · S/N 1523N5930USplendid Air Leasing LLC · Dover, DEBuilt 1970 · S/N 28-26726N5930WGraham James C Co-Trustee · Bellville, OHBuilt 1966 · S/N 28-3376N5930YHopkins Frank Michael · Wilmington, DEBuilt 1965 · S/N 27-3091N5931DStone Robert K · Piney Flats, TNBuilt 1956 · S/N 22-4594N5931UJ And H Aircraft Leasing Inc · Palmyra, PABuilt 1970 · S/N 28-26814N5932Autry Marbella A · Montrose, COBuilt 1973 · S/N 022N5932FWingin' It Aviation LLC · Glendale, CABuilt 1976 · S/N 28-7790144N5932URegistration Pending · Bulverde, TXRegistration pendingBuilt 1971 · S/N 28-7125143
Back to AD 87-10-06 R1