AD 76-06-06
Registered aircraft · 1,247
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:76-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-06-06')
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:76-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-06-06') 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.
N2489MBarker Gerald E · Weymouth, MAN2491MPope Geoffrey M · Bishop, CAN2492MSchaaf Terry L · Bowman, NDN2493MDriver Kegan Thomas · Billings, MTN2499MC & C Sierra LLC · Jackson, WYN2504MAerial Messages Leasing Co · Longwood, FLN2505MSever Jeffrey D · Anchorage, AKN2507MEller Ralph E · Wasilla, AKN2511MAustin Air Cruisers LLC · Dripping Springs, TXN2513MFinley Joel H · Sandwich, MAN251TGelvin Stanley M · Central, AKN2524MDd Leasing LLC · Aberdeen, IDN2526MTulin Donald J · Anchorage, AKN2528MJohnson Robert M · Mapleton, MEN2531MCurtis Kevin R · Flushing, MIN2533MJohnson Cory R · Owatonna, MNN2534MBooher John R · Eagle River, AKN2542MHudson Joseph M · Holly Springs, NCN2544MDeaton Mark · Gig Harbor, WAN2545MCopenhaver Patrick J · Enumclaw, WAN2547MCapozzi Tony · Seaford, DEN2549MOld Goat LLC · Wilmington, DEN2552MSchmidt Anthony D Jr · Jordan, MNN2553MRubbert Jan D · Upham, NDN2554MLensegrav Leslie C · Meadow, SDN2555MSchiller Jeffrey A · San Diego, CAN2556MTennyson Chad E · Ridgefield, WAN2557MSale Reported · Oklahoma City, OKSale reportedN2560MAicraft Leasing LLC · Orlando, FLN2563MDavidson Dan F · Ozona, TXN2564MMonger Douglas J · Helena, MTN2566MQuality Aviation Inc · Marana, AZN2569MSp Airparts LLC · Moscow, IDN256DNau Howard A · Melba, IDN2570MBills Nathan · Overland Park, KSN2572MChieftain LLC · Hot Springs, ARN2577MBales Colton E · Wasilla, AKN2579MBarela Peter A · Wasilla, AKN257AWWright Laura J · Hagerstown, MDN2581MSpencer David W · Anchorage, AKN2586MSmith Randall A C · North Pole, AKN2591MFlyer One LLC · Palm Harbor, FLN2594MBertke Matthew B · Anchorage, AKN2608MEhrenfelt Linda Mae · Pierre, SDN2612MGreenhalgh Janna L · Caldwell, IDN2615MKelsey Mike · Carey, IDN2620MBooth Chance · Wasilla, AKN2623MRegistration Pending · Anchorage, AKRegistration pendingN2638MBooth Wade W · Palmer, AKN2639MPense Douglas H · Fairbanks, AK
Back to AD 76-06-06