AD 93-24-13
Registered aircraft · 231
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:93-24-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-24-13')
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:93-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:93-24-13') 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.
N8624BSummit Peak Holdings LLC · Missoula, MTN8624GTemair LLC · San Francisco, CAN8624QRuckle Kelby J · Whittemore, MIN8625KRotor F28f LLC · Lake City, FLN8625WLuke Jahn A · Englewood, OHN8625ZMacarthur Gerald · Hillman, MIN8626ASouth County Helicopter LLC · Pilot Rock, ORN8626PMussche Roger H · Lafayette, INN8626SSkorecki Ryan A · Girdwood, AKN8630YM And M Aviation Inc · Oxford, MAN8631PSharkeys Helicopters Inc · West Lebanon, NHN8631YHarden Michael J · Washington, PAN88RWRhoads Timothy C · Logan, NMN88ZHLearn 2 Fly LLC · Cantonment, FLN8900XRotorcraft LLC · Lake Havasu City, AZN890JRFrasch Randy · Missoula, MTN898SYGordon Brett · Ewa Beach, HIN904TAWhirlwind LLC · Mifflinburg, PAN90BZMirand Alexander A · Huntington Beach, CAN91HBSale Reported · Hickory, NCSale reportedN920DPEnstrom Helicopter Corp · Menominee, MIN9285November 9285 LLC · Higden, ARN93DASeptember Bravo Enterprises LLC · West Olive, MIN93GPHorizon Helicopters Inc · Newark, DEN942MACorderman Michael · Armstrong, IAN9552Runge Kerry A · Crystal Lake, ILN962SMWheels Flying Service LLC · Kalispell, MTN965CCannon Travis H II · Corinth, TXN976XMackechnie Martin J · Palm Harbor, FLN98FWHysell Donovan W · Atwater, OHN99YCStyer David B · Pendleton, OR
Back to AD 93-24-13