AD 2012-26-16
Registered aircraft · 1,377
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:2012-26-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-16')
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:2012-26-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-16') 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.
N161AJGruener Garrett · Berkeley, CAN1621MLybl Air LLC · Billings, MTN162PBPapa Bravo Aviation LLC · Fort Lauderdale, FLN164CMaroon & Gold LLC · Albuquerque, NMN164RDIsland Park Aviation LLC · Fargo, NDN164SLife Flight Network LLC · Aurora, ORN166AFGeiger Holdings Inc · Portsmouth, NHN166SBNew Cingular Wireless Pcs LLC · Anchorage, AKN1677Le Loop LLC · Naples, FLN167AREdgemont Aviation LLC · Wilmington, DEN16FCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN16HQ10ke LLC · Okeechobee, FLN172AFDynasty Flight LLC · Portsmouth, NHN172JSCmfl LLC · Montgomery, ALN172PBLocker Inc · Muleshoe, TXN173CBer Company LLC · Albuquerque, NMN175ACBank Of Utah Trustee · Salt Lake City, UTN175WAOsprey Aviation LLC · Preston, IDN177NXLebeouf Bros Towing LLC · Houma, LAN178CMaroon And Gold LLC · Albuquerque, NMN178MHRegistered aircraftN178WFJb Air Holdings 1 LLC · College Grove, TNN179ALBank Of Utah Trustee · Salt Lake City, UTN17DPWde Aviation LLC · Atlanta, GAN17SEBeta Fleet LLC · South Burlington, VTN18007Stancil Builders Inc · Angier, NCN180NGCwa LLC · Saint Louis, MON183CGeorgia Air South Inc · Valdosta, GAN185PBStellar Envoy LLC · Arvada, CON188PCTimeless USA LLC · Wilmington, DEN189AFRmz LLC · Portsmouth, NHN18DSN18ds LLC · Mcminnville, ORN190ASInterport Aviation LLC · Newark, NJN190PEUS Department Of The Interior · Boise, IDN1919Phase 2 Aviation LLC · Miami, FLN191PEJmm Aviation LLC · Oakwood, GAN191PGDw Leasing LLC · Charlotte, NCN191SPJke Helm LLC · Spreckels, CAN1921UBank Of Utah Trustee · Salt Lake City, UTN192CPaso Aviation LLC · Winsted, MNN192CPRegistered aircraftN1932HAirmax LLC · Waukee, IAN194CSNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTN198TKEbac LLC · Wichita, KSN199CMPassmore Aviation LLC · Claremore, OKN19AEGbny LLC · Sheridan, WYN1CWAircw LLC · Charlotte, NCN1TCMarcare Aviation LLC · Gardnerville, NVN200NPRhys Vineyards LLC · Woodside, CAN201LFFreedom 2026 LLC · Minneapolis, MN
Back to AD 2012-26-16