OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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.

N8344PGulledge Richard · Deland, FLS/N 24-3600N8345PMcgough Christopher M Trustee · Hurricane, UTBuilt 1964 · S/N 24-3601N8346PPhelps Michael J Trustee · Oneida, TNBuilt 1964 · S/N 24-3603N8348PEchols Mark R · Diana, TXBuilt 1964 · S/N 24-3605N8348YNelson Brian · Wakefield, NEBuilt 1967 · S/N 30-1495N8349PPickett Douglas M · Romeo, MIBuilt 1964 · S/N 24-3606N834ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496314N8351PComanche Air Holdings LLC · Austin, TXBuilt 1964 · S/N 24-3608N8352YSkylandsair LLC · Port Orange, FLBuilt 1967 · S/N 30-1499N8353YSoutheast Leasing LLC · Delray Beach, FLBuilt 1967 · S/N 30-1500N8355PSutliff Larrie G · Briarcliff Manor, NYBuilt 1963 · S/N 24-3580N8356PEarl Tim G · Plymouth, CAS/N 24-3612N8357PHames David W · Amarillo, TXBuilt 1964 · S/N 24-3613N8358YGruenbaum Michael S · Eastvale, CABuilt 1967 · S/N 30-1505N8359YManyak Louis J · Inglis, FLS/N 30-1507N835ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496315N835NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496472N8360VGcgk Air Ventures LLC · Sheridan, WYBuilt 1981 · S/N 44-8107058N83628Gibson Stanley · Draper, UTS/N 44-8107048N8364PSheeree Corp · Wilmington, DES/N 24-3622N8365PHanna James L · Simi Valley, CAS/N 24-3623N8365YTwin Time LLC · Battle Lake, MNBuilt 1967 · S/N 30-1514N8366PBurris Robert V · Charlotte, NCBuilt 1964 · S/N 24-3624N8366YLieberman Bill A · Port Orange, FLBuilt 1967 · S/N 30-1516N8368PBoyko Michele A · Albuquerque, NMBuilt 1964 · S/N 24-3626N8368YMeadows Michael M · Cypress, TXBuilt 1967 · S/N 30-1518N8369PLeenhouts John R · Mulberry, FLBuilt 1964 · S/N 24-3627N836AFreese Pamela · Frederic, WIBuilt 1951 · S/N 22-163N836ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496316N8370PDonovan Patrick D · Troy, MOBuilt 1964 · S/N 24-3628N8371YAstro Star Aviation Inc · Niles, MIBuilt 1967 · S/N 30-1522N8373PZeller Ryan P · Reno, NVBuilt 1964 · S/N 24-3631N8375PGores Thomas J · Franklin, WIBuilt 1964 · S/N 24-3633N8375YSimmons John William · Ocala, FLBuilt 1967 · S/N 30-1529N8376AN8376a LLC · Orlando, FLBuilt 1981 · S/N 44-8107054N8376YScharfenberg Charles · Maquon, ILBuilt 1967 · S/N 30-1530N8377LMcmahon Jamin T · Gig Harbor, WABuilt 1981 · S/N 44-8107055N8377PGullett Samuel H · Lafayette, LABuilt 1964 · S/N 24-3636N8378PBel-Aire Home Restoration LLC · Platteville, WIBuilt 1964 · S/N 24-3637N8378YEmerald Aircraft LLC · Greenwood, SCBuilt 1967 · S/N 30-1533N8379YSpaeth Alexander H · Aurora, ILBuilt 1967 · S/N 30-1534N837HBKellum Mark · Belden, MSBuilt 1978 · S/N 27-7954021N837PGG & G Comanche LLC · Magnolia Springs, ALBuilt 1965 · S/N 30-914N8381PIndy Air Sales LLC · Anderson, INS/N 24-3640N8381YLehrer James Rodd · Thief River Falls, MNBuilt 1967 · S/N 30-1536N8382PKutilek Emil J · Charlottesville, VABuilt 1964 · S/N 24-3641N8383PWhatley Mark · Orion, MIBuilt 1964 · S/N 24-3642N8383YHolland Carl J · Dillsboro, INBuilt 1967 · S/N 30-1538N8384PMauch Archie C · Magnolia, TXBuilt 1964 · S/N 24-3643N8385YNesbitt Loyd B Jr · Independence, ORBuilt 1967 · S/N 30-1540
Back to AD 85-02-05 R1