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.
N206HESouthern Aircraft Consultancy Inc Trustee · Casper, WYN206JSMjolhus Knut G · Amarillo, TXN206JTTurner Jeffrey A · Birch Run, MIN206JZMercer-Fraser Co · Eureka, CAN206KSBailey April O · Papillion, NEN206MJTeufel Jessica L DBA · Hillsboro, ORN206NAInternational Air Services Inc Trustee · Carson City, NVN206NYHornet International LLC · Picayune, MSN206PC10wg LLC · Newman Lake, WAN206PHTaz Investments LLC · New Iberia, LAN206PLAerial Control Inc · Brentwood, CAN206RMPadgett Farms And Forestry LLC · Milan, GAN206RVTaylor Made Aircraft Co LLC · Broomfield, CON206RWUnited States Department Of Interior · Boise, IDN206RYEast Tennessee Helicopters Inc · Butler, TNN206SAGarlick Joyce M · Hamilton, MTN206SWCounty Of Ocean · Barnegat, NJN206TATomlinson Aviation Inc · Ormond Beach, FLN206TGGallien Anthony · Livermore, CAN206THRanger Aviation Leasing LLC · Wilmington, DEN206VLMalahaide Investments Inc · Wilmington, DEN206WAChem Air LLC · Shreveport, LAN206WGWorld Golf LLC · Charles City, VAN206XZSunwest Construction Enterprises Inc · Tarpon Springs, FLN206YYMshr Helicopter Service LLC · Chehalis, WAN206ZZAv Enterprises Inc · Bozeman, MTN207TVMidcoast Helicopter Inc · La Ward, TXN208ERAircraft Guaranty Corp Trustee · Oklahoma City, OKN209SKalispell Corp · Wilmington, DEN209TLTomalar Inc · Vero Beach, FLN20FLLocker Fred · Muleshoe, TXN20NMObrien Helicopters Inc · Fort Myers, FLN20SPNew York State Police · Albany, NYN20WYKelly Sean R · Bozeman, MTN210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN211CSWithrotor Aviation Inc · Lakeview, ORN212ELMark Mondo Building & Excavating Inc · Reno, OHN212SPAirman Helicopter Inc · Fort Lauderdale, FLN213PDDrb Helicopters LLC · Klamath Falls, ORN21470Southwest Heliservices LLC · Mesa, AZN21507Steuben Foods Inc · Elma, NYN2155ZHeli Incorporated · Las Vegas, NVN215MBunn Mary E · Williamstown, WVN21772N21772 LLC · Wellington, FLN217HKHolden Thomas J · Warrington, PAN21MWAir Flite Inc · Shawnee, OKN21RTL&R Investment Partners LLC · Wilmington, DEN220GPRotorheads Leasing LLC · Perham, MNN220PDCity Of Oakland · Oakland, CAN220SASpurger Aviation LLC · Spurger, TX
Back to AD 2012-14-06