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.

N2638MBooth Wade W · Palmer, AKBuilt 1946 · S/N 12-981N2639MPense Douglas H · Fairbanks, AKBuilt 1946 · S/N 12-977N2640MStraight Gary D · Wasilla, AKBuilt 1946 · S/N 12-982N2640PCrumley Emily M · Bristol, TNBuilt 1955 · S/N 22-2978N2641AWhitcomb Glenn R · West Richland, WABuilt 1952 · S/N 22-910N2641MGeorge Gary D · Humble, TXBuilt 1946 · S/N 12-983N2642MLons Travis W · King Salmon, AKBuilt 1946 · S/N 12-984N2645MSchwenke-Cram Kim · Madison, SDBuilt 1946 · S/N 12-979N2646MBelanger Bette · Wasilla, AKBuilt 1946 · S/N 12-1143N2647PTrinkle Aviation LLC · Kingsburg, CABuilt 1955 · S/N 22-2985N2649PHoffmann Greg L · Centennial, COBuilt 1955 · S/N 22-2987N264TPm Aviation LLC · Missoula, MTBuilt 1953 · S/N 18-2378N2650AKulick Douglas F · Reno, NVBuilt 1952 · S/N 22-920N2650PGodlewski John A · Ormond Beach, FLS/N 22-2988N2652PInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 22-2992N2653PKoerner Stephen F · Kankakee, ILBuilt 1955 · S/N 22-2993N2654PSamson Mason H · Rives Junction, MIBuilt 1955 · S/N 22-2994N2655MRenneke Wiest Lynnette E · Le Sueur, MNBuilt 1946 · S/N 12-978N2656MHaggstrom Daryl V · Fairbanks, AKBuilt 1946 · S/N 12-968N2657MCurtis Christopher J · Wasilla, AKBuilt 1946 · S/N 12-970N2660AN62689 Inc · Texarkana, TXBuilt 1952 · S/N 18-2184N2660PAnderson William B · Rogers, ARBuilt 1955 · S/N 22-3000N2663PHoffrage Michael B · Fresno, CAS/N 22-3003N2664AZmuda Bruce V · Eagle River, AKBuilt 1952 · S/N 18-2179N2665MProsser William C · Wasilla, AKBuilt 1947 · S/N 12-993N2666MBurt David R Jr · Justin, TXBuilt 1946 · S/N 12-1109N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390N2668PRegistered aircraftBuilt 1955 · S/N 18-4392N2669PLegends LLC · Willow, AKBuilt 1955 · S/N 18-4393N266SCChristensen Ty T · Wasilla, AKS/N 18-8435N26700Harvey Aaron J · New London, WIBuilt 1940 · S/N 4-864N26716Mottweiler Martin · Dowagiac, MIBuilt 1940 · S/N 4-859N26719Orlandi Properties LLC · Blairstown, NJBuilt 1940 · S/N 4140N2671MZoch Lori R · Port Orange, FLBuilt 1946 · S/N 12-972N26730American Airpower Heritage Flying Museum · Dallas, TXS/N 4-870N2673AWilde Air Service LLC · Volga, SDBuilt 1953 · S/N 22-933N26747Sale Reported · Altura, MNSale reported, pending cancellationS/N 4-888N2674MStarr LLC · Superior, WIBuilt 1946 · S/N 12-1107N26751Henderscheid Edward D · Mesa, AZS/N 4892N2675ATroyer Robert Earl · Toledo, WAS/N 20-952N26769Cascade Aerial Services LLC · Chehalis, WABuilt 1940 · S/N 4165N2677ML & L Farms · Richvale, CABuilt 1946 · S/N 12-1095N26797Three Doc'S #2 LLC · Fort Lauderdale, FLBuilt 1940 · S/N 4907N267CMRegistered aircraftBuilt 1954 · S/N 18-3532N26802Powers Harry R II · London, OHS/N 4-909N26809Johnson Joyce C · Cumberland, MDBuilt 1940 · S/N 4-911N26810Whiting Mark D · Champaign, ILBuilt 1940 · S/N 4190N26811Jacobs James A · Lakeview, MIBuilt 1940 · S/N 4191N26816Messerer Jonathan D · Duluth, MNFirst renewal noticeBuilt 1940 · S/N 4-913N2681AKatzmarek Clay M · Wasilla, AKS/N 18-2186
Back to AD 99-01-05 R1