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.

N9205YNorman Edward M · Palmer, AKBuilt 1970 · S/N 18-8913N9206DCarpenter Richard F · Big Lake, AKBuilt 1958 · S/N 22-6265N9206YFejes Samuel T Jr · Anchorage, AKBuilt 1971 · S/N 18-8921N9213YCarty Eric · Anchorage, AKBuilt 1971 · S/N 18-8918N92167Yedowitz Michael C · New Milford, CTS/N 16699N9216DBlackbird Aviation LLC · Bedford, PABuilt 1958 · S/N 22-6276N9217DBischoff Danielle I · Palmer, AKBuilt 1958 · S/N 22-6277N9218DMaestas Jonathan M · Wright City, MOBuilt 1958 · S/N 22-6278N921PCProppe Karl H · Needham, MABuilt 1992 · S/N 1809058N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282N9226DClf Industries LLC · Thornton, COBuilt 1958 · S/N 22-6286N9228DLavender James R · Gainesville, TXBuilt 1958 · S/N 22-6288N9229DStevens Mark F · Ocean Springs, MSBuilt 1958 · S/N 22-6289N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290N9242DWeishaar Wallace · Livingston, TXBuilt 1958 · S/N 22-6302N9243DPiper Aviation Museum Foundation · Lock Haven, PABuilt 1958 · S/N 22-6303N9244DShrode Rafe C · Jewett, TXS/N 22-6304N9247DLaw C Scott · Oklahoma City, OKBuilt 1958 · S/N 22-6307N924ANielsen Arvid L · Two Harbors, MNBuilt 1951 · S/N 22-228N92508Pierce Stuart · Ridgefield, WABuilt 1946 · S/N 12-31N9250DJouflas Nikos A · Anchorage, AKBuilt 1958 · S/N 18-6541N92511Mckay Donald A · Soldotna, AKS/N 12-34N92515Bowen Bruce C · Sturgis, SDBuilt 1946 · S/N 12-38N92536Ott Dean R · Carrollton, OHBuilt 1946 · S/N 12-60N92538Todd Terry A · Firth, IDBuilt 1946 · S/N 12-64N9253DHand Keith A · Anchorage, AKBuilt 1958 · S/N 18-6546N92544Walther Newell A · Wasilla, AKBuilt 1946 · S/N 12-73N92545Grald Jonathan · New Hampton, NYBuilt 1946 · S/N 12-74N92547Haynes John · Gainesville, GABuilt 1946 · S/N 12-76N92549Mackay Chadd P · Spokane Valley, WABuilt 1946 · S/N 12-78N92556Bender Ronald J · Columbus, NMBuilt 1946 · S/N 12-85N9255DNorstrom Hans P · Wasilla, AKBuilt 1958 · S/N 18-6548N92563Tri-County Sprayers Inc · Hamlin, TXBuilt 1946 · S/N 12-92N92569Bauer Dereck R · Springfield, ORBuilt 1946 · S/N 12-98N92571Ag Air Squadron Three LLC · Saint Joseph, ILBuilt 1946 · S/N 12-101N92576Oman Ronald G · Chugiak, AKBuilt 1946 · S/N 12-106N9257PBrooks Laura · Palmer, AKBuilt 1970 · S/N 18-8900N92582Eichner Kenneth B · Ketchikan, AKBuilt 1946 · S/N 12-112N92583Church Bryce G · Lava Hot Springs, IDBuilt 1946 · S/N 12-113N92585Hines Thomas J · Anchorage, AKBuilt 1946 · S/N 12-115N92587Harper Thomas R · Lakeway, TXBuilt 1946 · S/N 12-122N92588Graham Aviation LLC · Baton Rouge, LABuilt 1946 · S/N 12-118N92592Haggenmacher Scott · Jonesboro, ARBuilt 1946 · S/N 12123N925NEriksson Kurt R · Soldotna, AKBuilt 1978 · S/N 18-7909007N9261DBales Carson E · Wasilla, AKBuilt 1958 · S/N 18-6555N9261PUdell Brian · Queen Creek, AZS/N 18-8901N92620Goodrich Jeffrey W · Slaton, TXBuilt 1946 · S/N 16983N9264DCenter Charles C · Wasilla, AKBuilt 1958 · S/N 18-6562N9265DGagnon Matthew I · Fairbanks, AKS/N 18-6563
Back to AD 99-01-05 R1