AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13')
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:2005-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13') 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.
N6139QRanney Steven C · Cordova, AKN6152TSpate Aviation LLC · Albuquerque, NMN617PBBoillat Pascal · Olympia, WAN6181AHiline Inc · Ball Ground, GAN6181KBd Aviation LLC · Sundance, WYN6183BHegge Malik Trustee · Mills, WYN618PCMandes George J · Homer, AKN61FMIntegrity Aircraft Title Holdings LLC · Portland, ORN61PHTre Aviation Corp · Wilmington, DEN62409Costa James J · Goff, KSN624KRotary Flight LLC · Wilmington, DEN6295PCaribe Helicopters Inc · Coral Gables, FLN62EHJuliett Tango LLC · Alpine, WYN62FHelicopters Inc · Linden, NJN62UCCbft LLC · Mobile, ALN633JHJack Harter Helicopters Inc · Lihue, HIN63446Helicopter Services Of Illinois LLC · Fisher, ILN63864Aircraft Guaranty Corp Trustee · Oklahoma City, OKN63888Flick Todd · Skull Valley, AZN63SHMaine Helicopters Inc · Whitefield, MEN6401XCity Of Memphis · Memphis, TNN642ABCatalyst Aviation LLC · Hammonton, NJN648CAChem-Air LLC · Shreveport, LAN64GKAerospace Trust Management LLC Trustee · Wilmington, DEN64JBNc Transportation Inc · Loudon, NHN64RSRainbow Air Inc · Niagara Falls, NYN64TMLake State Companies LLC · Anchor Point, AKN65150Burns Craft LLC · Wilmington, DEN651RPPeasant Air LLC · Parkersburg, WVN65231Louisville Metro Government · Louisville, KYN652BBAgricultural Air Services LLC · Jupiter, FLN655HAHelicopter Applicators Inc · Gettysburg, PAN656HAHelicopter Applicators Inc · Gettysburg, PAN656TLTopside Aviation Inc · Brasstown, NCN657CCClear Creek Construction LLC · Lysite, WYN65CRWinco Inc · Aurora, ORN65DACenter For Vertical Studies LLC · Sheridan, WYN66013Blackbird Aero LLC · Boca Raton, FLN66RLSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66SDEnforcement Aviation Services Inc · Midway City, CAN67001Usda Aphis Ws Atoc · Cedar City, UTN67041Desoto County Sheriff Dept · Hernando, MSN67053West Hills Aviation Inc · Huron, CAN67099Spartanburg County Sheriffs Office · Spartanburg, SCN67110Mf Helicopters LLC · East Troy, WIN67113West Hills Aviation Inc · Huron, CAN67130Mf Helicopters LLC · East Troy, WIN67147Usda Aphis Wildlife Services · Cedar City, UTN67172Veturis David · Lake Forest, CAN67176Kootenai County Regional Air Support · Hayden, ID
Back to AD 2005-10-13