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.

N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193N4293RLaws Chris · Mckenzie, TNS/N 32-40671N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040N4293ZSuper Cub N4293z LLC · Creston, CABuilt 1967 · S/N 18-8603N42942Mott Plane LLC · Morning Sun, IABuilt 1983 · S/N 32-8306018N42945Pollnow Dean M · West Bend, WIBuilt 1983 · S/N 32-8306020N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663N4294NCoastal Aviation LLC · Virginia Beach, VABuilt 1983 · S/N 32R-8313011N4294PAex Enterprises LLC · Alexandria, LABuilt 1983 · S/N 32R-8329015N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134N4295RGhost Riders Aoo LLC · Altoona, PABuilt 1983 · S/N 28-8311014N4295VMcmahon Ian R · Locust Grove, GAS/N 71732N4296HBogart Sean A · Anchorage, AKBuilt 1948 · S/N 14-99N4296NScholz Daniel Joseph · Mantorville, MNBuilt 1983 · S/N 32-8306021N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196N4296RJohnstone Colin · Enterprise, ALS/N 32-40674N4296SB J Air Inc · Wilmington, DEBuilt 1983 · S/N 32-8306022N4296TD'Haem Christopher M · East Lansing, MIBuilt 1983 · S/N 32-8324009N4296XWilco Consulting LLC · Elkhart Lake, WIBuilt 1983 · S/N 32-8324010N4296ZSisk Michael Shaun · Steamboat Springs, COBuilt 1967 · S/N 18-8548N42979Dashanddash LLC · Athens, GABuilt 1983 · S/N 32R-8329021N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114N4297CEv Aviation LLC · Elizabeth, COBuilt 1983 · S/N 32R-8329019N4297HAirswiss Inc · Wilmington, DEBuilt 1978 · S/N 24-0699N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056N4297QCritchfield David P · Paradise, CAS/N 17260197N4297R4297 Romeo Aviation LLC · Owasso, OKBuilt 1969 · S/N 32-40675N4297ZAcadiana Cub LLC · Abbeville, LAS/N 18-8549N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050N42985Hall Jason · Iron Mountain, MIBuilt 1983 · S/N 32-8306023N42987Gman Air LLC · Clayton, MOBuilt 1983 · S/N 32R-8313017N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058N4298QDarrach Todd I · Rhome, TXS/N 17260198N4298RAv79 Aviation LLC · Dover, OHBuilt 1969 · S/N 32-40677N4298ZAugustine Ryan M · Talkeetna, AKBuilt 1967 · S/N 18-8555N4299HCompton James D · Griffin, GABuilt 1948 · S/N 14-103N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799N4299RRimlinger Timothy Trustee · Audubon, PABuilt 1969 · S/N 32-40678N4299XFerguson Teresa · Houston, ARBuilt 1983 · S/N 32-8324012N4299ZKauffman Loren C · Anchor Point, AKS/N 18-8558N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99N429BJJohnston Richard Max Trustee · Sierra Madre, CAS/N 40410N429CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8691N429DRConard John C · Minnetonka, MNS/N 60412N429EGCongalton Steve M · Rancho Cucamonga, CABuilt 1974 · S/N 28-7405188N429EPBbm Air LLC · Macon, GAFirst renewal noticeBuilt 2001 · S/N 17280608N429ESBarbers Point Flight School LLC · Kapolei, HIBuilt 1997 · S/N 17280296N429FSSimmons Frederick G · Lake Hiawatha, NJBuilt 1971 · S/N 32-54
Back to AD 87-10-06 R1