AD 2013-20-13
Registered aircraft · 861
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:2013-20-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:2013-20-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:2013-20-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:2013-20-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.
N23SDNorth Wind Aviation LLC · Chelan, WAN23TVKd Helicopters Inc · Shingleton, MIN23WKChemair Helicopters Inc · Jefferson, WIN243WWSunflower Helicopters LLC · Hebron, NEN244WWGeronimo Corp · Natchez, MSN245ARN245ar LLC · Ocala, FLN245WWWithrotor Aviation Inc · Lakeview, ORN246WWValley River Leasing Inc · Murphy, NCN247WWAtlas Aviation LLC · Nebraska City, NEN248WWFarwest Aviation LLC · Billings, MTN249WWLarson Helicopters LLC · Perham, MNN24TVApexheli Oregan Inc · Florence, ORN250CADelta Whiskey LLC · Somers, MTN250DEAkheli99 LLC · Anchorage, AKN255SPPhoenix Precision Air LLC · Centreville, MIN260ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN260BHPowcres LLC · Pequannock, NJN260LRCenterline Holdings · Camden, DEN261SPMbm Aviation Consultants Inc · Wilmington, DEN262BHLcs Energy Inc · Dover, DEN263CHWos Holdings IV LLC · Belgrade, MTN2650North Texas Helicopters Inc · Newark, TXN267MWPacific Valley Aviation Inc · Arbuckle, CAN2681RFarley Delbert · Victorville, CAN26BL58d Leasing LLC · Plover, WIN26MVTjr Ltd · Excelsior, MNN26NKLsk Leasing LLC · Lewes, DEN2751ACollective Aviation Services · Orient, IAN2756PChemair Helicopters Inc · Jefferson, WIN27574Ranger Aviation Leasing LLC · Wilmington, DEN2760KTre Aviation Corp · Wilmington, DEN2762PSale Reported · Rantoul, KSSale reported, canceledN2773RWarren Smith Contracting Inc · Flagstaff, AZN27758Dragonfly Aviation LLC · Saint Ansgar, IAN2779RMace Robert C · Queen Creek, AZN277KATwin Cities Aviation Inc · Yuba City, CAN277LSG & G Transporation LLC · Queen Creek, AZN277RLSan Juan Aviation LLC · Wilmington, DEN27JBCape Gyro Inc · North Chatham, MAN27UKOrlando Aircraft Sales LLC · Orlando, FLN28373Hornet International LLC · Picayune, MSN283XLThiel Air Care Inc · Chowchilla, CAN284CAOrgan Mountain Aviation Co LLC · Las Cruces, NMN289RLL&R Investment Partners LLC · Wilmington, DEN28EDWilliams Management & Consulting Inc · Anacoco, LAN28HTL&R Investment Partners LLC · Wilmington, DEN28LGZeliff Aviation LLC · Batavia, NYN28UKOas2 LLC · Orlando, FLN290LHLarson Helicopters LLC · Perham, MNN2927WGulf Coast Helicopters Inc · Pearland, TX
Back to AD 2013-20-13