AD 2011-01-52
Registered aircraft · 416
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:2011-01-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52')
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:2011-01-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52') 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.
N8938FSouthern Cross Aviation Inc · Wilmington, DEN8944FFitzgerald Brian B · Gettysburg, PAN8948FO Reilly Thomas P · Oscoda, MIN8950FAloft · Haiku, HIN8962FEmbry Aero Ltd · Greenville, ILN8973FAvelan Enterprises Inc · Elm Grove, LAN8990FDeon Esterhuizen Inc · Clearwater, FLN8SLLauff Samuel Jr · Ocala, FLN90270Dunn Larry W · Anderson, SCN90271Gartman Jerald B · Morehead City, NCN90586Lauff Samuel Jr · Ocala, FLN9061RCavender Matt · Howe, TXN9061SObrien Derrick P · Lehigh Acres, FLN9064SCain James W · Big Rapids, MIN907ALTjm Ventures Inc · Rio Verde, AZN911THDagnon Scott R · Driggs, IDN911VCDetgen Ernest J · Carmen, OKN916JGGriffin Aerospace Solutions LLC · Bridgeport, WVN9282FBox Helicopters Inc · Cotulla, TXN9286FFlying High Like A Bird In The Sky · Longwood, FLN9291FHealey David A · Hammondsport, NYN92PCEnright Arne P Trustee · Ward Cove, AKN931CPTriggs Andrew · Las Vegas, NVN9323FCouch Bill A · Palestine, TXN9326FLelys · Orland, CAN9333FFire Bird Aviation Inc · Vivian, LAFirst renewal noticeN9333VFletcher Jeffrey A · Belle Chasse, LAN9350FSale Reported · Perry, GASale reported, pending cancellationN9361FRmw Services LLC · Mckee, KYN9369FSauer David A · Palmetto Bay, FLFirst renewal noticeN9374FPierson Robert N · Nora, MNN9385FReynolds Darryl G · Wills Point, TXN9390FPennington Mitchell T · Medley, WVN9423FAvex Holdings Heli Inc · Lewes, DEN9428FBargo Aviation Services LLC · Crittenden, KYN9440FPatton Phillip F · Gold Hill, NCN9442FRhodes Terry G · Snohomish, WAN9468FColeman Harold D · Pikeville, KYN9485FGonzales David M · Corvallis, ORN9489FHensley Richard · Bertram, TXN9492FDeer Creek Helicopters LLC · Chico, CAN9504FRons Air Service Inc · Two Buttes, CON9516FKelly David · Issaquah, WAN9517FS Martinez Livestock Inc · Moxee, WAN95583Reynolds Darryl G · Wills Point, TXN9559FGeco Inc · Wilmington, DEN9561FBarrows Carl A · Lisle, NYN9563FClunie David A · Bangor, PAN9569FClassic Helicopter Corp · Auburn, WAN958CPJoslyn Larry J · Las Vegas, NV
Back to AD 2011-01-52