AD 2012-11-05
Registered aircraft · 305
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:2012-11-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-05')
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:2012-11-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-05') 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.
N7819Slyline Technologies LLC · Woodside, CAN800SCMalcom Scott O · Toledo, WAN80193Fisher Larry L Jr · Saint Charles, MIN811ZRhoads Timothy C · Logan, NMN825SHJ L Loewen Md Sc · Niagara, WIN84DHStanton Mark I · Spokane, WAN857MMVigilante Helicopters LLC · Lewistown, MTN8617HToutant Roland J · Woodstock, CTN86198Styer David B · Pendleton, ORN8619ACowboy Up Aviation LLC · Frenchglen, ORN8620CLrh Equipment LLC · Pendleton, ORN8622EChapin Ray DBA · Geneva, NYN8622UMiller Mark E · Willow, AKN8622XNorthern Construction Inc · Haines, AKN86238Crawford Thomas P · Elgin, ILN86239Lrh Equipment LLC · Pendleton, ORN8623BLrh Equipment LLC · Pendleton, ORN8623TAmerican Adventure Dreams LLC · Dover, DEN86243Miller Mark · Willow, AKN86244Burke Clint H · Olympia, WAN8624BSummit 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, PAN8652QEnstrom Helicopter Corp · Menominee, MIN88RWRhoads Timothy C · Logan, NMN88ZHLearn 2 Fly LLC · Cantonment, FLN8900XRotorcraft LLC · Lake Havasu City, AZN890JRFrasch Randy · Missoula, MTN898SYGordon Brett · Ewa Beach, HIN89GPOsprey Aviation LLC · Green Bay, WIN904TAWhirlwind LLC · Mifflinburg, PAN90BZMirand Alexander A · Huntington Beach, CAN911WFHelin Bruce A Trustee · Flagstaff, AZN91HBSale 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, MT
Back to AD 2012-11-05