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.
N2762MRaymond Mark A · East Jordan, MIN2765MExperimental Aircraft Association Chapter 1218 · Willow Springs, MON2770MThissell David W · Plymouth, MAN2772MDexter Fred H · Live Oak, FLN2773MWinby Elize Aj · Palo Alto, CAN2778MMiller Benny · Canutillo, TXN2780MHerrington James W · Locust Grove, GAFirst renewal noticeN2784MWarwick Steven D · Middletown, DEN2785MWood Gregory M · North Pole, AKN2789MDagostino Scott J · Bozeman, MTN2794MRifenburg Brian K · Ward Cove, AKN27DSWillis Bernie W · Wasilla, AKN2800DHamann Russell M · Clear Lake, SDN2808MJensen John C · Mccleary, WAN2809MCarlos Sean N · Togiak, AKN2810MDavis Ronald L Jr · Soldotna, AKN2814MBruggeman Michael J · Saint Paul, MNN2819MDzr Enterprises LLC · Missoula, MTN2820MFlynt Gary J · Baytown, TXN2821MPacker Louis M · Wasilla, AKN2823MFedorka Paul R Trustee · Soldotna, AKN2827MAdams James M · Pontiac, ILN2829MAlaska Media LLC · Anchorage, AKN2830MMullins Esten R · El Paso, TXN2836MSwihart Matthew S · Hood River, ORN2845MBrasher Kerry W · Scotts Hill, TNN2849M49 Mike Partnership · Erie, CON2850MHarvey Timothy A · Colusa, CAN2853MH&M Aviation · Hazelton, NDN2862MFrederick David · Juneau, AKN2870MJohnson James F · Florence, MTN2875MSzumal Brent · Wasilla, AKN2876MJohnson William A · Dillingham, AKN2880MAbalama Arthur C · Bethel, AKN2883MRegistered aircraftN2888MLapoint Daniel L Jr · Bellevue, MIN2892MFoster Randy · La Grange, TXN2898MPutman John Vick · San Antonio, TXN2901MRickard William A · Virginia Beach, VAN2902MKelsey Michael O · Carey, IDN2903MKrog Steven L · Hartford, WIN2904MLange Keith J · Wasilla, AKN2906MFry Steven G · Eagle River, AKN2907MKutschera Thomas C · Youngsville, NYN2910MEkdahl John Edward · Freehold, NJN2913MMccay Brian D · Earlysville, VAN2914MPannone Steven R · Palmer, AKN2916MBradford Murvin L · Hensley, ARN2918MGuess Gerald Bryan · Hernando, FLN2919MPiccione Joseph A · Washington, NJ
Back to AD 76-06-06