AD 82-16-08
Registered aircraft · 112
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:82-16-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-08')
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:82-16-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-08') 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.
N5378GElectra Aero Inc · Manassas, VAN5383GAj'S Aviation Inc · Spring Hill, FLN5387GWinged Vision Inc · Gaithersburg, MDN5399GPanzarino Anthony V · North Hills, CAN5450EMiller Byron W · Silverton, ORN5455EHaddix Christopher W · Chugiak, AKN5479GTeufel Brothers Enterprises LLC · Hillsboro, ORN565JSYundt Joshua J · Wasilla, AKN606DMMangels Dale E · Bremerton, WAN61JADa Bear LLC · Wilmington, DEN62HCN62hc LLC · Nunica, MIN62JAHelio Alaska Inc · Chugiak, AKN6301VValley River Leasing Inc · Murphy, NCN6304VConover Dale L · Wasilla, AKFirst renewal noticeN6306VCoyle William L · Kiowa, CON6318VShoultys Shawn P · Denali Park, AKN6319VAlaska Aviation Museum · Anchorage, AKN631KEJames Rogers Mcconnell Air Museum Inc · Carthage, NCN6324VBranham Chris R · Anchorage, AKN6334VDelaney Blair · Portland, ORN6340VTurbine Motor Conversions LLC · Pullman, WAN6342VRainbow River Lodge Aviation LLC · Sandy, UTN641LWCloud Splitter Inc · Columbia, CAN6450VHopkins Curtis Trustee · Lakeside, CAN6454VThompson Johnny Je · Coppell, TXN6463VFrolander Christopher G · Chugiak, AKN6464VWright Air Service Inc · Fairbanks, AKN6465VMonberg Robert M · North Pole, AKN6468VGlasheen Sean T · Bethel, AKN6469VCarter Russell · Chugiak, AKN6470VLaxson William W · Anchorage, AKN6471VBauder Kyle J · Anchorage, AKN6478VWright Air Service Inc · Fairbanks, AKN6487VAirborne Scientific Inc · Overland Park, KSN67DDDietz Michael D · Big Lake, AKN68857Wright Air Service Inc · Fairbanks, AKN68858Betz Tim · Anchorage, AKN68874Hutchison Thomas L · Kimberly, IDN68882Tri-Gear Aviation LLC · Land O Lakes, FLN68883Baker Jack B · Naples, IDN68884Barren Creek LLC · Mardela Springs, MDN68890Capital Air Services LLC · Ridgeland, MSN69VJLucida Group US LLC · Anchorage, AKN6DBCameron Mark D · Alpine, WYN713CWright Air Service Inc · Fairbanks, AKN717RWRainbow River Lodge Aviation LLC · Sandy, UTN74MWAvions Frousses LLC · Evanston, WYN777LFAeolian Corp · Wilmington, DEN808BDAviation Trust Co LLC Trustee · Oklahoma City, OKN80THHackwell Matthew Calvin · Enoch, UT
Back to AD 82-16-08