AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-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:2016-05-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:2016-05-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:2016-05-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.
N636BDavid Aviation Inc DBA · Brandon, MSN636KTRustair Inc · Anchorage, AKN636QDQuest Diagnostics Clinical Laboratories Inc · Reading, PAN636TAToth Financial Advisory Corp · Leesburg, VAN637LAMaxwell Flying Service Inc · Benoit, MSN637PCAir Methods LLC · Greenwood Village, CON637PHCapital Holdings 137 LLC · Tavernier, FLN639LAJ & R Flying Service LLC · Alicia, ARN63AWAmerican Ag Aviation Inc · Five Points, CAN63TPHot Air LLC · Cambridge, MAN63VAFairey Ltd · Grand Junction, CON640Teufel Holly Farms Inc · Portland, ORN640DFWhy Not LLC · Montezuma, KSN640MYManatee Jet Club LLC · Bradenton, FLN641LALake Air Service LLC · Jennings, LAN641SMRiverside Air LLC · Shelby, MSN642Snow Goose Aviation LLC · Anchorage, AKN642KAPatriot Ag Air LLC · Huntington, INN642PCAir Methods LLC · Greenwood Village, CON643EAAir Adventures Corp · Charleston, SCN643PCRegistered aircraftN644SDSierra Delta LLC · Lititz, PAN645PCValiair Limited Co Trustee · Casper, WYN648DDDashdale Aviation LLC · Fort Dodge, IAN649PBoutique Air Inc · Dallas, TXN64FFSanford Health · Sioux Falls, SDN650BGP & M Aero LLC · Belle Chasse, LAN650DMMaroon Creek LLC · Aspen, CON650MCN650mc LLC · Bountiful, UTN650TRRichard Flying Service Inc · Rayne, LAN651PBJm Aviation LLC · Ocala, FLN652JWWalters Aviation LLC · Hilliard, OHN653DPBank Of Utah Trustee · Salt Lake City, UTN654FMN654fm LLC · Kalispell, MTN655MWMarvin Lumber And Cedar Company · Warroad, MNN655SCStandridge Color Corp · Social Circle, GAN658LAPontiac Flying LLC · Pontiac, ILN658PCAir Methods LLC · Greenwood Village, CON65AFAngel Fire Express II LLC · Southlake, TXN65MGRegistered aircraftN-number assigned (import), not yet registeredN65MTM&M Transit LLC · Winter Park, FLN65TADodson International Parts Inc · Rantoul, KSN65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN660EMBenoit Aerial Spraying Inc · Bourbonnais, ILN660KPWorsham Farms Flying Service Inc · Camilla, GAN660MCMcguires Flying Service LLC · Obion, TNN660RARichter Aviation Inc · Maxwell, CAN660TRTri-Rotor Spray & Chemical · Ulysses, KSN661EKGi Aviation LLC · Denver, CO
Back to AD 2016-05-13