OpenAirDocs.org
AD 49-50-01

Registered aircraft · 9,190

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:49-50-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:49-50-01')
  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.

N1000HMumm Scott A · Brodhead, WIBuilt 1948 · S/N 15AC-2N1002EMccurdy James R · Hampden, MEBuilt 1946 · S/N 7AC-4552N1003HLight Winds Aviation LLC · Bay City, MIBuilt 1948 · S/N 15AC-5N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730N1005HMaier Dennis J · Morristown, SDBuilt 1948 · S/N 15AC7N1007PSimpson Tad M · Decatur, ILBuilt 1986 · S/N 101N1009HHardey John R · Wasilla, AKBuilt 1948 · S/N 15AC-11N100ZYWalden Taylor G · Pueblo, COBuilt 2016 · S/N ONEN1010HA2 Aero LLC · Ann Arbor, MIBuilt 1949 · S/N 15AC-347N1011HUlm Gabrielle Nicole · North Pole, AKBuilt 1948 · S/N 15AC-13N1012Papon Bruce · Hardtner, KSBuilt 1947 · S/N 11BC-106N1013HWhite Theodore F · Willow, AKBuilt 1948 · S/N 15AC-15N10149Price John · Bennington, KSS/N P-510N10169Mccroskey Danny D · Ward, ARS/N 101N10188Maggio Rocco M · Waupaca, WIBuilt 1947 · S/N 7BCM-4N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749N101RKettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 2125N1026ELampros James C · Salem, ORBuilt 1946 · S/N 7AC-4577N1028HConnell Michael J · Decorah, IABuilt 1948 · S/N 15AC-31N102BEEbers Vincent A · Wellsville, MOBuilt 2003 · S/N 6-1851N102ZXJurado Lance M · Ocklawaha, FLBuilt 2008 · S/N 1101N1031HHardy John R · Wasilla, AKBuilt 1948 · S/N 15AC-34N1032EDannecker Christopher T · Lake City, FLBuilt 1946 · S/N 7AC-4583N1033BRudd Wayne G · Basalt, COBuilt 1979 · S/N 1N10341Gravesen Kelly D · Decatur, GAS/N 18-2124N1034HBuergel Sandra J · East Aurora, NYBuilt 1948 · S/N 15AC-37N1035HKnapp Louis L · Fairbanks, AKBuilt 1948 · S/N 15AC-38N103FFKnoll G C Jr · Clarendon, ARBuilt 1964 · S/N 1N103WEEngel Douglas A · Plainfield, ILS/N 2537N10433Sodak Angus Inc · Reva, SDBuilt 1951 · S/N 20128N10448Thompson Steven R · Pauls Valley, OKS/N 7CCM-24N10450Grantham George F · Covington, LABuilt 1947 · S/N 7BCM-97N10456Registered aircraftBuilt 1956 · S/N 7BCM-432N1048HBeuschel Timothy W · Mount Pleasant, WIS/N 15AC-59N10493Jarnagin William E · Brandon, FLBuilt 1956 · S/N 7BCM341N1049CGerbi Charles R Trustee · Auke Bay, AKS/N 11-1027N1049HSavage David E · American Falls, IDBuilt 1948 · S/N 15AC-62N104BKnl Associates LLC · Mansfield, OHBuilt 1946 · S/N 2533N104GMRegistered aircraftBuilt 1999 · S/N 1036N10500Brauer Michael V · Ozark, ALBuilt 1956 · S/N 47-1183N10504Short David · Warrensburg, MOBuilt 1956 · S/N 47-1120N10508Loffert George U Jr · Killeen, TXS/N 7DC-502N1050KLynden Aeronautical Services LLC · Lynden, WABuilt 1946 · S/N 3777N10516Ness David · Minneapolis, MNBuilt 1981 · S/N 1N1051HPoulter John W · Sharpsburg, GABuilt 1948 · S/N 15AC-66N10520Eiteuner Mark P · Saint Helen, MIBuilt 1947 · S/N 47-1106N10525C&L Aviation LLC · London, WIBuilt 1948 · S/N 48-464N10526Giarraputo Gary L · Beaumont, TXBuilt 1956 · S/N 7CCM-42N1052EMiller Matthew · Santa Maria, CABuilt 1946 · S/N 7AC-4603N1052HFay Bernard E · Eagle, AKBuilt 1948 · S/N 15AC-69
Back to AD 49-50-01