OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-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:99-01-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.

N5528ZSmith Ryan M · Midland, TXS/N 22-9317N5529HMonson Stan D · Billings, MTBuilt 1949 · S/N 11-1032N552DPPflegl Henry A · Oregon City, ORS/N 5-742N5530ZReeves Todd J · Mosier, ORS/N 22-9319N5531ZDarr Henry S · Drummond, MTBuilt 1962 · S/N 22-9321N5532HStout Walt · White Hills, AZBuilt 1949 · S/N 11-1035N5533HG2g Aeroservices LLC · Medina, OHBuilt 1949 · S/N 11-1036N5535ZPayne Dustin J · Weirsdale, FLS/N 22-9325N5536HSands Donald R · Yukon, OKS/N 11-1039N5537ARobinson Albert B · Byhalia, MSS/N 20-776N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944N5538HDilse Ted D · Scranton, NDBuilt 1949 · S/N 11-1042N5538ZBradburn William P · Pearl River, LAS/N 22-9328N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945N5539HAlexander Steven T · Wasilla, AKS/N 11-1043N553GHGrand Ronald J · Saint Cloud, MNS/N 11-1033N5541ZSpivey Harold E · Thomaston, GABuilt 1961 · S/N 22-8958N5543ZKiendl Philip R · Carabaset Vly, MEBuilt 1962 · S/N 22-9334N5544HDykstra Dennis D · Marion, SDS/N 11-1048N5544ZBetween The Seams Inc · Locust Grove, GABuilt 1962 · S/N 22-9335N5545HGreen Bob · Belgrade, MTBuilt 1949 · S/N 11-1049N5545ZPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 22-9337N5546ZKooima John C · Rock Valley, IABuilt 1962 · S/N 18-7848N5547HFisher Garrett L · Sheridan, WYS/N 111050N5548BManna Farms Inc · Sherwood, NDBuilt 1949 · S/N 11-1053N5548ZJurgens Noel G · Mound City, KSFirst renewal noticeBuilt 1962 · S/N 22-9340N5549ZRegistration Pending · Bloomsburg, PARegistration pendingBuilt 1962 · S/N 22-9341N554JCCouch Kent E · Bend, ORBuilt 1955 · S/N 18-4132N5550ZShippers Michael S · Williamson, NYBuilt 1962 · S/N 22-9342N5551HLeavengood Thomas Richard · Dallas, IABuilt 1949 · S/N 11-1062N5551ZKons Emily Ap · Bear Creek, WIBuilt 1962 · S/N 22-9343N5552ZBurns William C · Vernon, MIS/N 229344N5554ZWeddle Curtis E · Iowa Park, TXBuilt 1962 · S/N 22-9347N5555ZKramer Brian J · Seattle, WABuilt 1962 · S/N 22-9348N5556HUrbanowski Edward F · Paxton, MAS/N 11-1067N5557HPetrik Patty O Personal Representative · Sidney, MTBuilt 1949 · S/N 11-1068N5559HBiswell Bryce D · Corning, CABuilt 1949 · S/N 11-1072N555AXWalsh David · North Platte, NEBuilt 2001 · S/N 9927CCN555GBGreen Chad W · Wasilla, AKS/N 18-6379N555JBPerkins Robert Tahte · Anchorage, AKBuilt 1959 · S/N 18-7102N5560HMax Wings LLC · Wilmington, DEBuilt 1949 · S/N 11-1073N5561HLeisner David L · Palmer, AKS/N 11-1074N5561ZHoward David D · Winner, SDBuilt 1962 · S/N 22-9358N5562HLovley Forrest T · Jordan, MNBuilt 1949 · S/N 11-1075N5563ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1962 · S/N 22-9360N5564HCapps James T Sr · Rutledge, ALBuilt 1949 · S/N 11-1085N5566ZAlex Lawrence P · Loves Park, ILBuilt 1962 · S/N 22-9363N5567HMutzig Steven M · Sheridan, WYBuilt 1949 · S/N 11-1089N5569ZLevandowski Joseph · Hamburg, NYBuilt 1962 · S/N 22-9273N5570HBaker Robert D · Mc Kees Rocks, PABuilt 1949 · S/N 11-1092
Back to AD 99-01-05 R1