AD 86-06-08 R1
Registered aircraft · 491
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:86-06-08-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-06-08-R1')
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:86-06-08-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-06-08-R1') 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.
N74005Newton Property Leasing LLC · Greene, IAN74081Kehoe Keith J · Marion, TXN74084Boger Roger · Ludington, MIN74120Slevin Mary Elizebeth · Altamont, NYN74124Bowles Alan B · Georgetown, TXN74822Nockair Inc · Longboat Key, FLN74823Tobler Hans P · Anchorage, AKN74898James David R · Wayne, MIN755ELavanture Richard A · Bristol, INN7574Charles Farms Inc · Lancaster, PAN7575Barr Andrew B · Beulah, MSN7576Classic Rotors Museum · Ramona, CAN7578Scotts Helicopters Service Inc · Le Sueur, MNN7579Coastal Helicopters Inc · Panama City, FLN7730Gay Richard L · Middleville, MIN7732South Atlanta Helicopters LLC · Hampton, GAN7736Shank Brian · Manheim, PAN7762Peterson Chester L · Spring, TXN7764Reeves Mark S · Baldwinsville, NYN77DPDt Pralle Enterprises Inc · Hampton, IAN7800SSlykerman John A · Bakersfield, CAN7801SRital Copter Service Inc · Hudson, IAN7802EContinental Helicopters Inc · Mason, TXN7832SSjd Aviation LLC · Nescopeck, PAN7836SWilbur-Ellis Co · Salinas, CAN7841SChurchill Scott W · Le Sueur, MNN7860SMagnum Aviation LLC · Goff, KSN7861SBrown Helicopter Inc · Pensacola, FLN7862STimeless Air Classics LLC · Kalispell, MTN7863SSpears Jason M · Milton, WVN7878Hendrickson Flg Svc Inc · Rochelle, ILN7885SWilbur-Ellis Co · Salinas, CAN7887BLidija LLC · Grass Valley, CAN7887SHeli Works Flight Services LLC · Deer Lodge, MTN7888BMorten David J · Larimore, NDN78900Master Designs LLC · Gilbert, AZN7893BDykstra Donald J · Dorr, MIN7897SChap Jerry L · Patagonia, AZN7920SMeyer Kevin · Hooper, NEN7925JChurchill Scott · Le Sueur, MNN7928SGardenville Project LLC · Watkins, CON7936STriple F Flying Inc · Benton, PAN7959JFallini Joe B Jr · Tonopah, NVN7965JDsm Inc · White City, ORN797WSWild Goose Of Plant City LLC · Thonotosassa, FLN7985AGiles Forrest D · Springtown, TXN7ARAircraft Sales LLC · Caledonia, MIN7NBMagnum Aviation LLC · Goff, KSN804JFTriple S Aviation LLC · Wilmington, DEN8051EPatterson Casey Paul · Kinston, AL
Back to AD 86-06-08 R1