AD 2012-10-13
Registered aircraft · 13,306
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-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:2012-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:2012-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:2012-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.
N826JKMmv Holding LLC · Indianapolis, INN826KENorthern Renegade Properties LLC · Duluth, MNN826MGOrten Symer Enterprises Inc · East Hampton, NYN826MMCavu Flying LLC · Kohler, WIN826MTG T Acft Inc · Franklin Square, NYN826TWHartland Aviation LLC · New Smyrna Beach, FLN8272BAndy-Oxy Co Inc · Asheville, NCN8274QBravo Delta II LLC · Steamboat Springs, CON8275ASigillito Michael A · Vero Beach, FLN8275QAbel Derek R · Rio Vista, CAN8277DValiair Lc Trustee · Casper, WYN8277FFletcher Holdings Of Nc 2.0 LLC · Winston Salem, NCN8277MBlalock Paul T · Longview, TXN8278TRegistered aircraftN827APelican Flyers LLC · Metairie, LAN827CDSwiss Wings Inc Trustee · Wilmington, DEN827CTN44uk Partners LLC · Burlington, WAN827DJStorm Horse Systems LLC · Bedford, NYN827EAElite Air LLC · Wilmington, DEN827HELocke Ventures LLC · Southaven, MSN827LLHotel Mike LLC · Dayton, OHN827RPJireh Aviation LLC · Zeeland, MIN827SStamp Jeffrey · Little Rock, ARN827TCDecker Tobin James · Avon, INN827URJoby Aero Inc · Santa Cruz, CAN827WFCarlton Paul K Jr · College Station, TXN8285CBonanza Enterprise LLC · Tucson, AZN8285MCohen Aviation LLC · Rolla, MON828ABChasen Dreams LLC · Hurricane, WVN828BPHot Wings Aviation Ltd · Wilmington, DEN828CCoriolis Inc · Brooklyn, NYN828DTTspy Services Inc · Wilmington, DEN828ECPrescient Aviation LLC · Los Angeles, CAN828EXHorizon Strategies Aviation LLC · Dover, DEN828GFrancis Rick Trustee · Pleasanton, CAN828GGOrtho Hand Aviation LLC · Lewes, DEN828JHDonnelly Mark A · San Jose, CAN828KGGray Enterprises Investing LLC · Wentzville, MON828KMSjr Holdings LLC · Raleigh, NCN828KPKapa International · Santa Monica, CAN828LPentacrown Svr Clr LLC · Little Rock, ARN828LEKnights Templar Aviation LLC DBA · Rossville, TNN828LLOlsen Leasing LLC · Hendricks, MNN828LMSletten Mark W · Saint Jacob, ILN828MBBel Aviation LLC · West Bloomfield, MIN828MEHungerford Properties LLC · Cockeysville, MDN828MRLooking Beyond LLC · Burlington, VTN828MWCoop Michael P Sr · Sylva, NCN828PMRobinson Shannon D · Fair Oaks Ranch, TXN828PSCampbell Terry G Trustee · San Francisco, CA
Back to AD 2012-10-13