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.

N8610PTapert Warren F · Lenox, MIBuilt 1964 · S/N 24-4063N8611YCragg Gordon E · Georgetown, TXBuilt 1968 · S/N 30-1751N8612DPerry Leonard M · Soldotna, AKBuilt 1957 · S/N 22-5812N8612PFranz James T · Glendale, AZBuilt 1964 · S/N 24-4064N8613DPerry Kenneth V · Katy, TXS/N 22-5811N8613PAkin Tiffany · Dalhart, TXBuilt 1965 · S/N 26-140N8614CErdmann Adam C · Raseau, MNBuilt 1953 · S/N 22-1295N8614PLee Patrick J Jr · Lindstrom, MNBuilt 1964 · S/N 24-4065N8614YD&D Maintenance LLC · Etna Green, INBuilt 1968 · S/N 30-1754N8615YUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1968 · S/N 30-1755N8616DFrancis Harvey B · Key West, FLS/N 22-5815N8617DGrisham Michael H · Paulden, AZBuilt 1957 · S/N 22-5820N8617PFrisbie Kevin R · Fairfield, IABuilt 1964 · S/N 24-4067N8618LLatimer Lawrence A · Vernon, TXBuilt 1969 · S/N 25-5047N8618YGroup Aire II · Manitowoc, WIBuilt 1968 · S/N 30-1758N8619DBenton Mark H · Sussex, WIBuilt 1957 · S/N 22-5822N8619LAerial Banners Inc · Pembroke Pines, FLBuilt 1969 · S/N 25-5049N8619PStewart Mark A · Mccall, IDBuilt 1964 · S/N 24-4068N8619YNuse Aviation LLC · Hollidaysburg, PABuilt 1968 · S/N 30-1759N861APKlein Edwin Andrew Bell · Grass Valley, CABuilt 1957 · S/N 22-4769N861KSKansas State University · Salina, KSBuilt 2024 · S/N 4496573N8620DMid Atlantic Air Museum · Reading, PAS/N 22-5823N8621DBrown Lonnie S · Lone Jack, MOBuilt 1957 · S/N 22-5824N8621YParks Ashton · Pepperell, MABuilt 1968 · S/N 30-1762N8622DGrass Strip Life LLC · Gulf Breeze, FLBuilt 1957 · S/N 22-5825N8622YClosson Luke E Jr · Valdosta, GABuilt 1968 · S/N 30-1763N8623PMajor Development LLC · Cedaredge, COBuilt 1964 · S/N 24-4070N8624CPanter Edwin M · Anchorage, AKBuilt 1953 · S/N 22-1304N8624PAviation Classics Ltd · Reno, NVBuilt 1965 · S/N 26-146N8624YRegistered aircraftBuilt 1968 · S/N 30-1765N8625DMyers Martin John Trustee · Juneau, AKBuilt 1958 · S/N 22-5828N8626YThomas William R · Rochester, MNBuilt 1968 · S/N 30-1767N8627LSouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1969 · S/N 25-5060N8627PRegistered aircraftBuilt 1964 · S/N 24-4101N8629CSmith Kevin B · Kempner, TXBuilt 1953 · S/N 20-1007N8629DLogan Todd S · Bucyrus, OHBuilt 1957 · S/N 22-5832N8629LKnutson Wayne R · Thompson, NDBuilt 1969 · S/N 25-5063N8629YFarris Mark E · Richmond, KYBuilt 1968 · S/N 30-1770N862KSKansas State University · Salina, KSBuilt 2024 · S/N 4496586N8630PSpanjer Blake L · Crete, NEBuilt 1964 · S/N 24-4073N8631CBrandt Jason A · Boyd, TXS/N 22-1321N8631DMilford Terry R · Mcminnville, TNBuilt 1957 · S/N 22-5834N8632CWalker Michael L · Fredericksburg, TXBuilt 1953 · S/N 22-1324N8632DFranklin Jay D · Cashmere, WABuilt 1957 · S/N 22-5835N8632PCarleton Dennis M · Sewickley, PABuilt 1964 · S/N 24-4074N8632YDream Flyers LLC · Cherry Hill, NJBuilt 1968 · S/N 30-1773N8635YLysiuk Lance · Andover, CTS/N 30-1776N8636CJoyce Patrick J · El Cajon, CABuilt 1953 · S/N 22-1315N8636DRui C LLC · Reddick, FLBuilt 1957 · S/N 22-5844N8637CLamphere John M · Middle Island, NYBuilt 1953 · S/N 22-1310
Back to AD 85-02-05 R1