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.
N2640MStraight Gary D · Wasilla, AKN2641MGeorge Gary D · Humble, TXN2642MLons Travis W · King Salmon, AKN2645MSchwenke-Cram Kim · Madison, SDN2646MBelanger Bette · Wasilla, AKN2655MRenneke Wiest Lynnette E · Le Sueur, MNN2656MHaggstrom Daryl V · Fairbanks, AKN2657MCurtis Christopher J · Wasilla, AKN2665MProsser William C · Wasilla, AKN2666MBurt David R Jr · Justin, TXN2671MZoch Lori R · Port Orange, FLN2674MStarr LLC · Superior, WIN2677ML & L Farms · Richvale, CAN2681MHebrink Jason R · Grand Rapids, MNN2682MDavis Philip L · Spring Hill, TNN2683MBeach Banners Inc · Jacksonville, FLN2684MGrangruth Rory A · Wadena, MNN2686MCummings Scott Alan · Monitor, WAN2687MWilkes Gary W · Lakeland, FLN2689MKuehni Steven A · Stanley, WIN2691MHartmaier Robert S Jr · Monroe Township, NJN2692MOnstott Norman V · Mount Pleasant, MIN2694MSwartz William L · Cumb Foreside, MEN2699MJohnson George W · Seattle, WAN26QQHauser Family Flying LLC · Mount Pleasant, PAN2701MBaltrum Daniel R · Ester, AKN2706MEs LLC · Tulsa, OKN2707MKarpik Joseph Paul · Floodwood, MNN2708MKiceniuk Taras · Santa Paula, CAN2712MCardinal Adventures LLC · Green Bay, WIN2713MBeacon West LLC · Billings, MTN2718MLibby Justin C · Anchorage, AKN2719MCenter Charles C · Wasilla, AKN2720MCalderwood Kenneth E · Kenai, AKN2722MInfinity Aviation LLC · Piedmont, SDN2732MEaa Aviation Foundation Inc · Oshkosh, WIN2734MGraves Dorel E · Danville, INN2735MScott Chase · Anchorage, AKN2736MBrummer Christopher P · Wasilla, AKN2737MGautreau Peter F · Chickaloon, AKN2738MKerner Frank W · Saint Charles, MON2740MWroe Daniel C · Denton, MDN2743MKemp Dale W · Lampasas, TXN2746MStonecipher Wayne H · Yamhill, ORN2747MGuy Vaughn Zindel III · Eden, UTN2748MLathrop Patrick W · Kent, WAN2754MWheaton Lee H · Patten, MEN2755MKerwin Peter M · Naperville, ILN2757MHaring Clay · Lincoln, KSN2758MHaring Clay · Lincoln, KS
Back to AD 76-06-06