AD 2012-01-11
Registered aircraft · 3,100
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-01-11')
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-01-11')
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-01-11') 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-01-11') 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.
N11PNIvlje LLC · Chicago, ILN11SMMusser Scott S · Pasco, WAN11WKPage John · Carmel, CAN1201MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1206DMagnolia Underground Construction Inc · Byhalia, MSN120APredictive Bytes LLC · Houston, TXN120ACNiebla Holding LLC · Miami, FLN120JFElad LLC · Bend, ORFirst renewal noticeN120TNLf Cirrus LLC · Sarasota, FLN1215CColer Aviation Ltd · Zanesville, OHN1218MGmm Aviation LLC · Los Altos, CAN1219SAviodeck Inc Trustee · Wilmington, DEN121ABAbl Jets LLC · New York, NYN121ACBrooks Jimmie Patrick · New Braunfels, TXN121CDChampion Aviation Enterprises LLC · Acworth, GAN121DAIron Air LLC · Saint Albans, MON121JBRegistered aircraftN121KPBennett Lumber Products Inc · Princeton, IDN121LWAutomation Aviation LLC · Murfreesboro, ARN121PCC&N Holding Corp · Spicewood, TXN1227WErlich Austin · Los Angeles, CAN122DRCirrus Sr22t 1824 Inc Trustee · Wilmington, DEN122ECBronte LLC · Boise, IDN122JKBenhaven Aviation LLC · Red Lodge, MTN122JRSisto Donato · Rye, NHN122MBSuncrest Industries Inc · Lake Forest, CAN122MTKing Aviation Services LLC · Marietta, OHN122SMCirrus Aircraft LLC · Middletown, DEN122SPPort Cyber Aviation Sr LLC · Austin, TXN122SZValiair Lc Trustee · Casper, WYN122VAVollman David B · Bunkie, LAN122WPCirrus Design Corp · Duluth, MNN122ZM122 Zulu Mike LLC · Wheaton, ILN1231BRise Companies Aviation LLC · Hawley, MNN123BGCirrus Design Corp · Duluth, MNN123DHStrategic Initiative LLC · Onawa, IAN123FUGm321go Aviation Group LLC · Prescott, AZN123KEDesautels Jean · Laud By Sea, FLN123PCRegistered aircraftN123VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN123X123x LLC · Seattle, WAN123XAOkruch Aviation LLC · Tempe, AZN1244CCoulter Michael Ryan · Rehoboth Beach, DEN124CBPalmer Robert Preston · Santa Barbara, CAN124FBAdma Leasing LLC · Winter Park, FLN124JMRnav 17 Holdings LLC · San Antonio, TXN124LZLima Zulu Aircraft Corp · Los Angeles, CAN124PKNextlayer Tech LLC · Montgomery, ALN124RKOne Goat Enterprises LLC · Scottsdale, AZN125RLAdams Aviation Services Inc Trustee · Wilmington, DE
Back to AD 2012-01-11