Registered aircraft · 132

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

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:75-10-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:75-10-01') ORDER BY n_number

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:75-10-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:75-10-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.

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:75-10-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:75-10-01')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4027DFour Creeks Aviation · Visalia, CAS/N 5072 N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081 N4029SSlikker Flying Service Inc · Buttonwillow, CABuilt 1980 · S/N 5129 N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180 N40346Rutland Flying Service · Ridge Spring, SCBuilt 1982 · S/N 5192 N4035LFour Creeks Aviation Inc · Visalia, CABuilt 1982 · S/N 5199 N4277XHigh Country Helicopter LLC · Blowing Rock, NCBuilt 1981 · S/N 5161 N430NRRutland Flying Service Inc · Ridge Spring, SCRegistration expired, pending cancellationS/N 2074 N440NRMagnum Aviation LLC · Goff, KSBuilt 1964 · S/N 2275 N4415Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1960 · S/N 2040 N47063Geco Inc · Wilmington, DEBuilt 1962 · S/N 1422 N47077Knutson Flying Service Inc · Tioga, NDBuilt 1957 · S/N 947 N492HSChamberlain Paul E · Troup, TXBuilt 1959 · S/N 1141 N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321 N504HAEastern Stearman Inc Trustee · Leesburg, VAS/N 5004 N5098YMachacek Kenneth DBA · Midland, TXBuilt 1978 · S/N 5031 N513HAMagnum Aviation LLC · Goff, KSBuilt 1977 · S/N 5013 N514HAMagnum Aviation LLC · Goff, KSBuilt 1976 · S/N 5014 N518HAClassic Helicopters LLC · Choteau, MTBuilt 1977 · S/N 5018 N5325VBouschor William V · Curtis, WABuilt 1959 · S/N 954 N535HASummit Helicopters Inc · Salem, VABuilt 1977 · S/N 5035 N5362VSale Reported · Xxx, OKSale reportedS/N 2050 N5363VEvergreen Avn & Space Museum & The Capt Michael · Mcminnville, ORBuilt 1960 · S/N 2049 N5374VBank Of Utah Trustee · Salt Lake City, UTBuilt 1961 · S/N 2073 N5381VNorthwest Helicopters LLC · Olympia, WAS/N 2080 N543HAMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 5043 N58BABank Of Utah Trustee · Salt Lake City, UTBuilt 1957 · S/N 969 N6006KSummit Helicopters · Salem, VAS/N HA3083 N6032ESummit Helicopters Inc · Salem, VABuilt 1996 · S/N 5232 N6145GChamberlain Khaythan · Lodi, CABuilt 1982 · S/N 5177 N62347Dechene Corp · Big Lake, MNFirst renewal noticeBuilt 1961 · S/N 1247 N62361Horizon Helicopters LLC · Toms River, NJBuilt 1975 · S/N 1067 N62372Classic Helicopters LLC · Choteau, MTBuilt 1960 · S/N 1229 N62392Crawford James B Jr · Salmon, IDBuilt 1964 · S/N 1591 N62455Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1962 · S/N 1438 N62458Bank Of Utah Trustee · Salt Lake City, UTBuilt 1962 · S/N 1404 N6470Slikker Flying Service Inc · Buttonwillow, CABuilt 1963 · S/N 1601 N65048Bartlett Robert E · Cleveland, TXBuilt 1964 · S/N 1722 N65NWFour Creeks Aviation Inc · Visalia, CABuilt 1964 · S/N 2364 N67065Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 1023 N67155Horizon Helicopters LLC · Toms River, NJBuilt 1961 · S/N 1335 N686PSimply Living LLC · Fort Myers, FLS/N 592783 N689HSTexxon Resources Inc · Winter Park, FLFirst renewal noticeBuilt 1959 · S/N 1169 N702WAFort Wolters Helicopter Inc · Mineral Wells, TXS/N 2185 N703WAAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1963 · S/N 2276 N70904Fort Wolters Helicopter Inc · Mineral Wells, TXS/N 5100 N7090QFort Wolters Helicopter Inc · Mineral Wells, TXS/N 2248 N7090VFort Wolters Helicopter Inc · Mineral Wells, TXS/N 5181 N7173FFour Creeks Aviation Inc · Visalia, CAS/N 2011 N7173SCraig Helicopters Inc · Craig, COBuilt 1965 · S/N 2351

Back to AD 75-10-01