AD 2011-12-10
Registered aircraft · 2,765
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:2011-12-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-12-10')
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:2011-12-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-12-10') 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.
N115VCPoulikakos Aspasia D · Kifissia AthensNon-citizen corporation, flight hours not reportedN116PGUnusual Attitudes LLC · Bates City, MON116VKAirborne LLC · Wilmington, DEN117BAChopper Ag Services LLC · Samson, ALN117LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeN1189Aeroluxe Aviation LLC · Nashville, TNN118YLExecutive Helicopters Inc · Myrtle Beach, SCN119MJN119mj LLC · Honolulu, HIN119SMPrestige Worldwide Helicopters LLC · Waukesha, WIN11BMRobinson Helicopter Co · Torrance, CAN11GACrosswind Leasing LLC · Prescott, AZN11HNVstol Aviation LLC · Houston, TXN11RAMonkey Biziness LLC · Cherryville, NCN120ABHawaii Pacific Aviation Inc · Kailua Kona, HIN120AFAir First LLC · Kalispell, MTN1212NHgh Holdings LLC · Wilmington, DEN121AHSoul Shine LLC · Nashville, TNN121MEEvergreen Empire LLC · Delano, CAN121RHHelirod LLC · Oro Valley, AZN121SESpitzer Helicopter LLC · Woodland Hills, CAN121SXRegistered aircraftN121TVSky Helicopters Inc · Eustace, TXN122AACnt Aviation LLC · Lake Tapps, WAN122AKBarker Paul II · Rainbow City, ALN122JGRepublic Construction Industries LLC · Englewood, OHN122PLSlip Stream Aviation Inc · Fort Mill, SCN122RFDaniels Ronald C · Poughkeepsie, NYN122YBRobinson Helicopter Co · Torrance, CAN12396Helicopteracademy.Com LLC · Rehoboth Beach, DEN123MPPrairie River Farm Inc · Watertown, SDN123MVEmerald City Aircraft Leasing Inc · Port Orchard, WAN123SUSouthern Utah University · Cedar City, UTN123YWMaxwell Truck And Equipment LLC · State College, PAN12424Helicopter Academy Com LLC · Rehoboth Beach, DEN12475Helicopteracademy.Com LLC · Rehoboth Beach, DEN124ASJm Helicopters And Cattle LLC · Boynton Beach, FLN124HHRotorwing LLC · Sheffield, ILN12536Helicopteracademy.Com LLC · Rehoboth Beach, DEN1253PMaco Aviation Inc · Dayton, WAN125WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN12615Helicopter Academy.Com LLC · Rehoboth Beach, DEN12699Helicopteracademy.Com LLC · Rehoboth Beach, DEN126GGRobinson Helicopter Co · Torrance, CAN126NSHelileasing Inc · Las Vegas, NVN126SKSoky Helicopters LLC · Bowling Green, KYN126VAHuber Airpark Civic Club LLC · Seguin, TXN12715Helicopteracademy.Com LLC · Rehoboth Beach, DEN1273Taf Investments LLC · Doraville, GAN127DMAircraft Leasing LLC · Peoria, ILN127SHWaverly R22 LLC · Oklahoma City, OK
Back to AD 2011-12-10