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.

N2784PStogner Michael E · Cuber0, NMBuilt 1955 · S/N 18-4418N27857Cain Jeffrey J · Denver, COBuilt 1940 · S/N 4-1077N27858Lust Gary L · Iowa City, IABuilt 1940 · S/N 4-1078N2785MWood Gregory M · North Pole, AKS/N 12-1164N27868Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 41089N27873Lenning Zacariah D · Fort Wayne, INBuilt 1940 · S/N 4-1098N2787PNeubauer Scott · Wolf Point, MTBuilt 1955 · S/N 18-4421N27887Lawrence Glenn R · Rochester, MABuilt 1940 · S/N 41112N27892Herrington Jimmy Jr · Rayville, LAS/N 41119N27894Fisher Christopher J · Nora, ILBuilt 1940 · S/N 4-1116N27899Merrick Connor D · Wendell, IDS/N 41122N2789MDagostino Scott J · Bozeman, MTBuilt 1946 · S/N 12-1184N278ZKennerson Robert L · Palmer, AKBuilt 1981 · S/N 18-8109030N27905Bashaw Pete H · Camas, WABuilt 1940 · S/N 5-48N27915Gruner Carl O · El Cajon, CAS/N 5-53N2791PMccarthy Air LLC · Palmer, AKBuilt 1955 · S/N 18-4426N27923Goebel William R · Rhome, TXBuilt 1940 · S/N 4451N2792PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4427N27943Nedwick Lars I · Girdwood, AKS/N 5-62N2794MRifenburg Brian K · Ward Cove, AKS/N 12-1252N27967Dirigo Aerospace Solutions LLC · Sumner, MEBuilt 1940 · S/N 4482N27972Miller Rondo T · Coon Rapids, MNBuilt 1940 · S/N 5-69N27973Registered aircraftBuilt 1941 · S/N 4487N27974Crossroads Farms Inc · Aurora, NES/N 4486N27980Donnelly Brian J · Norwood, NYBuilt 1940 · S/N 5-80N27998Macginnis Thomas L · Ludlow, VTBuilt 1940 · S/N 4496N27999Bradshaw William D · Mc Bee, SCBuilt 1940 · S/N 5-78N279TAspenglow LLC · Talkeetna, AKS/N 18-2393N27BATerrill Dana R · Port Angeles, WABuilt 1952 · S/N 22-819N27DSWillis Bernie W · Wasilla, AKBuilt 1947 · S/N 12-2654N2800DHamann Russell M · Clear Lake, SDBuilt 1947 · S/N 12-1637N2800ZRitchie John A Jr · Gold Hill, NCBuilt 1959 · S/N 22-6793N28019Siegel Joanne R · Reading, PABuilt 1940 · S/N 4519N2801ZValiair Limited Company Trustee · Casper, WYBuilt 1959 · S/N 22-6794N2802ZPeavler Christopher · Modoc, SCS/N 22-6795N2803PLewis Stephen R · Chillicothe, ILBuilt 1955 · S/N 22-3095N28040Plane Fun Inc Tr Trustee · Snellville, GABuilt 1940 · S/N 4538N28042Sas Aviation LLC · Carroll, OHBuilt 1940 · S/N 4542N28046Mcquown Todd J · Montgomery, TXBuilt 1940 · S/N 5-90N28050Griggs Gerald W · Goddard, KSBuilt 1940 · S/N 5-88N28063Strauss Kenneth W · Vashon, WABuilt 1940 · S/N 5-89N28080Mages James G · Jordan, MNS/N 5-95N28083Cheshire Daric · Portland, ORBuilt 1940 · S/N 5-99N28084Clark Christopher W · Fallon, NVBuilt 1940 · S/N 5-98N2808MJensen John C · Mccleary, WAS/N 12-1261N2808PValiair Limited Co Trustee · Casper, WYBuilt 1955 · S/N 22-3101N2809MCarlos Sean N · Togiak, AKBuilt 1946 · S/N 12-1265N2809PDavis Gerald R · Hernando Beach, FLS/N 22-3102N280SEKennicott Wilderness Air LLC · Boonton, NJBuilt 1954 · S/N 18-3803N280TKrengel Lawrence E · Marengo, ILBuilt 1953 · S/N 18-2394
Back to AD 99-01-05 R1