AD 2000-16-05
Registered aircraft · 428
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:2000-16-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:2000-16-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:2000-16-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:2000-16-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.
N8866FReynolds Darryl G · Wills Point, TXN8871FGarvey Michael · Leesville, SCN8872FCameron William Douglas Jr · Lexington, VAN8887FNiec Steven M · Clio, MIN8891FDetgen Jim · Traverse City, MIN88QQJprg Aviation Inc · Orlando, FLN8901FBrookside Aero LLC · Grants Pass, ORN8911FA And J Aviation Services LLC · Titusville, FLN8913FLay Jerry K · Minonk, ILN8925FAztec Aviation · Geneseo, ILN8928FDenver Aerospace Science Museum · Watkins, CON8938FSouthern 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, OR
Back to AD 2000-16-05