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.
N5217CHydro Wings Inc · Valle Crucis, NCN521ADBarringer Aviation LLC · Waxhaw, NCN521BTBennett Brady R · Pinehurst, NCN521CDSale Reported · KasselSale reportedN521DGNikair LLC · Billings, MTN521LCRegistered aircraftN-number assigned (import), not yet registeredN521LMTavallaee Mehrdad M · Ashland, OHN521MMEagle Topflight LLC · Cape Girardeau, MON521PBravo Lima LLC · Hudsonville, MIN521PWDoghouse Aviation LLC · Vienna, VAN521SGPerfect Landing Aviation LLC · Highlands Ranch, CON521TSJustice William F · Calabasas, CAN521WPRudiarius Transportation De LLC · Jacksonville, FLN521WSCmt Properties LLC · Laurel, MSN521XDDacey Michael C · Pismo Beach, CAN521YJessconn Charters LLC · Steamboat Springs, CON521ZHoffner Flying Inc · Yankton, SDN521ZAProclaim Aviation Management LLC · Las Vegas, NVN521ZMThompson Russell Clayton · Hartland, MIN5223AGeneral Plumbing Inc · Walnut Creek, CAN5225VKuhn Chad · Boulder, WYN5226RBuncamper Theodore · St MaartenN5227JSbs Partnership · Henderson, NVN5228KD/S Aviation LLC · Las Vegas, NVN5228VDynamite Marketing Inc · Meridian, IDN522ACrowe Aviation LLC · Vestavia, ALN522ARMedic Choppers LLC · Springdale, ARN522CDFbm LLC · La Porte, INN522CMMueller Clark · San Jose, CAN522CPFly Cirrus LLC · Murrieta, CAN522DDHw Aviation LLC · Largo, FLN522DXFd Aircraft LLC · Summit, NJN522FDCirrus Design Corp · Duluth, MNN522GHQuailridge Aviation LLC · Clarkston, WAN522KGJdi Electrical Solutions Inc · Temecula, CAN522MGParker James V · Cashiers, NCFirst renewal noticeN522PDCirrus Design Corp · Duluth, MNN522PKE-Rksd LLC · Lake Success, NYN522PUFlying Club LLC · New York, NYN522PWPw Cirrus 2013 LLC · Naperville, ILN522RKMoney 2 Noise LLC · Phoenix, AZN522SRDias Antonio M · Scottsdale, AZN522TRegistered aircraftN522VCommodore Aviation LLC · Danville, ALN522WMJaybirds Aviation LLC · Saint Cloud, MNN522WTTme Cirrus LLC · Virginia Beach, VAN523ACJibber Aviation LLC · Westfield, MAN523BASale Reported · Rexburg, IDSale reportedN523CHawk Unlimited LLC · Kalispell, MTN523CMMelrose Law Pllc · Waynesville, NC
Back to AD 2012-10-13