AD 2012-14-06
Registered aircraft · 1,066
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-14-06')
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-14-06')
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-14-06') 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-14-06') 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.
N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2215GPntp LLC · Springville, UTN221GPChemair Helicopters Inc · Jefferson, WIN221TGCollier Mosquito Control District · Naples, FLN222HAJasons Helicopter Services · New Prague, MNN2240WYarak Aviation LLC · Big Timber, MTN224KMStatzel Steve DBA · New Haven, MON2251WJohnson Aerial Spraying LLC · Brayton, IAN225HRHeliwild Investments LLC · Austin, TXN225PDBaton Rouge Police Department · Baton Rouge, LAN2266ADt Pralle Enterprise Inc · Hampton, IAN2268GCrm Investments Inc · Wilmington, NCN2268WChorman Spraying LLC · Milton, DEN226WANewton Property Leasing LLC · Greene, IAN22743Applebee Aviation Inc · Banks, ORN2275QSierra Bravo Aviation Inc · San Francisco, CAN2277AMountain Helicopters LLC · Salt Lake City, UTFirst renewal noticeN22823Steve Wright Enterprises Inc · Alpine, CAN228KKKeagy Ken · Central Point, ORN2295FNorgrain Helicopters LLC · Hattiesburg, MSN2297EWestwind Helicopters Inc · Santa Fe, TXN2299UCb Couch Inc · Walcott, ARN229HLAviation Advantage Inc · Tabor City, NCN22EAHmc Lift LLC · Wilmington, DEN22NHSchuh Roger J · Chowchilla, CAN22PYEzell Holdings LLC · Tucson, AZN230MBFlyin Time LLC · Circleville, OHN230MDAir2 LLC · Blountville, TNN231RLNor Wes Inc · Creston, IAN233HCA7p Trust Co Inc Trustee · Cheyenne, WYN233WHBank Of Utah Trustee · Salt Lake City, UTN234JRPortland Helicopters LLC · Portland, MEN235JPPechacek Justin · Snyder, TXN23SDNorth Wind Aviation LLC · Chelan, WAN23TVKd Helicopters Inc · Shingleton, MIN240FLAir2 LLC · Blountville, TNN241JHChatham County Mosquito Control · Savannah, GAN243WWSunflower Helicopters LLC · Hebron, NEN244WWGeronimo Corp · Natchez, MSN245ARN245ar LLC · Ocala, FLN245WWWithrotor Aviation Inc · Lakeview, ORN247WWAtlas Aviation LLC · Nebraska City, NEN249WWLarson Helicopters LLC · Perham, MNN24TVApexheli Oregan Inc · Florence, ORN250CADelta Whiskey LLC · Somers, MTN255BPVictoria County Sheriff · Victoria, TXN255SPPhoenix Precision Air LLC · Centreville, MIN25LBScotts Helicopter Services Inc · Le Sueur, MNN260LRCenterline Holdings · Camden, DEN2618WEnglish Air Service LLC · Georgetown, TXFirst renewal notice
Back to AD 2012-14-06