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.

N5238NHuggins Charles R · Wasilla, AKBuilt 1955 · S/N 18-1929N5238ZMayer David J · Ingleside, ILS/N 22-8918N5239NDougherty Jennifer · Delta Junction, AKBuilt 1953 · S/N 18-2927N5239ZMellor Brad A · Spanish Fork, UTBuilt 1961 · S/N 22-8919N523SCBush Rider LLC · Erwinna, PABuilt 1951 · S/N 18-670N5240HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 16-44N5240ZReise Robert A · Meredith, NHBuilt 1961 · S/N 22-8920N5242HJohnson Steven D · Oklahoma City, OKFirst renewal noticeBuilt 1949 · S/N 16-46N5242ZLund Thomas S · Boulder, COBuilt 1961 · S/N 22-8924N5243HKirk Douglas R · Benzonia, MIBuilt 1949 · S/N 16-47N5243ZJinkins Richard D · Rewey, WIS/N 22-8925N5247ZBard Alexander T · Portland, ORS/N 22-8930N5248ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8931N5249ZCreger Paul L Jr · Springport, MIBuilt 1961 · S/N 22-8933N524BEPhilipsen Ben · Colleyville, TXBuilt 1951 · S/N 18-1650N524DRRegistered aircraftBuilt 1963 · S/N 18-7948N5250HPhilyaw Dale A · Lafayette, INBuilt 1949 · S/N 16-54N5252ZLamb Steve E · Big Bear City, CABuilt 1961 · S/N 22-8936N5253HBerry Milo A · Clarinda, IABuilt 1949 · S/N 16-57N5254ZPongracz Lajos Janos · San Antonio, TXBuilt 1961 · S/N 22-8939N5255HNorth Anthony · Rockwood, MEBuilt 1949 · S/N 16-59N5255ZGeorge James C · Lenoir, NCBuilt 1961 · S/N 22-8940N5256ZKirkpatrick Theodore J · Gwinn, MIBuilt 1961 · S/N 22-8941N5258HFrenzel Carl O · Midlothian, TXBuilt 1949 · S/N 16-62N525TSBurch Gary L · Ocala, FLBuilt 1951 · S/N 18-1164N5260ZBerreman Jeffrey P · Yakima, WABuilt 1961 · S/N 22-8945N5261HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-65N5261ZKnight Lynn L · Pineville, LAFirst renewal noticeBuilt 1961 · S/N 22-8948N5263HWelch I Jay · Concrete, WABuilt 1949 · S/N 16-67N5263ZWilkins Jerry D · Toledo, WABuilt 1961 · S/N 22-8950N5264HRaichl Andrej L · Astoria, ORBuilt 1949 · S/N 16-68N5265HHarper Clayton E · Seabrook, TXBuilt 1949 · S/N 16-69N5266HFritz Flying Service Inc · Lincoln, NES/N 16-70N526KGWalters David M · Wasilla, AKS/N 18-4294N5271ZElliot Kirk R · Tulsa, OKBuilt 1961 · S/N 22-8963N5272ZScheda Mark R · Brockport, NYBuilt 1961 · S/N 22-8965N5274ZKotek Steven G · Sparta, WIBuilt 1961 · S/N 22-8967N5275ZRobertson James W · Cashmere, WABuilt 1961 · S/N 22-8968N5276HYagcioglu Deniz S · Eatonton, GABuilt 1949 · S/N 16-80N5277HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-81N5279HHarris Joe Paul Trustee · Goldsby, OKBuilt 1949 · S/N 16-83N5279MTownsend Tod N · White Sulphur Spgs, MTBuilt 1949 · S/N 18-119N527JFBonnell Kenneth M · Ormond Beach, FLS/N 22-5755N527YMues John C · Wasilla, AKBuilt 1946 · S/N 12-312N5283ZRegistered aircraftBuilt 1961 · S/N 22-8978N5284HCampbell Peter R · Edgewater, FLS/N 16-89N5284ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8980N5285JJensen Michael J Trustee · Sterling, AKBuilt 1959 · S/N 18-7143N5285YHanson O John · Kaycee, WYBuilt 1964 · S/N 18-8138N5288ZSimmons Joshua I · Crescent City, CAS/N 22-8984
Back to AD 99-01-05 R1