AD 75-01-05
Registered aircraft · 108
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:75-01-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-05')
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:75-01-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-05') 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.
N101VDTempest LLC · Reno, NVN109MAMinuteman Aviation Inc · Missoula, MTN10RFBrown Helicopter Inc · Pensacola, FLN117DRNorthwest Helicopters I Inc · Olympia, WAN121PTLrh Equipment LLC · Pendleton, ORN133Brown Helicopter Inc · Pensacola, FLN134AWAmerican Wings Air Museum · Blaine, MNN134RVTempest LLC · Reno, NVN1363WWithrotor Aviation Inc · Lakeview, ORN137USThomas Aviation LLC · Orleans, CAN145MAMinuteman Aviation Inc · Missoula, MTN154TLJtbam Inc · Lakeside, AZN16315Army Aviation Heritage Foundation And Flg Museum · Hampton, GAN17HXHelicopter Express LLC · Chamblee, GAN198HMR & R Conner Aviation LLC · Conner, MTN204AQTamarack Helicopters Inc · Stevensville, MTN204DSGreenwood Helicopters Inc · Washington, NCN204DXFarwest Aviation LLC · Billings, MTN204GPJones Aviation Inc · Biggs, CAN204JBPremier Aircraft Services LLC · Bakersfield, CAN204PJJones Flying Service Inc · Biggs, CAN204UHR&R Conner Aviation LLC · Conner, MTN205BDVentus Ff LLC · Boise, IDN205BTRedding Air Service Inc · Redding, CAN205DYIdaho Helicopters Inc · Boise, IDN205FUAir 1 LLC · Newark, DEN205VCVentura County Sheriffs Department · Camarillo, CAN2252APremier Aircraft Services LLC · Bakersfield, CAN22753Martins Dusters Inc · Colusa, CAN234SJPorter Flying Services Inc · Chico, CAN256KTKord Technologies Inc · Huntsville, ALN262RCUS Airlift Command Inc · Anderson, SCN264RMRocky Mountain Construction LLC · Klamath Falls, ORN2650NIaba LLC · Norfolk, VAN2773HSummit Helicopters Inc · Salem, VAN283HFArmy Aviation Heritage Foundation And Museum Inc · Hampton, GAN28HXHelicopter Express LLC · Chamblee, GAN30111Sky Walker Aviation LLC · Indianapolis, INN3053QWest Valley Aviation Inc · Five Points, CAN313BNorthwest Helicopters Inc · Olympia, WAN333XLCj Air LLC · Nezperce, IDN334WNPope Jim D DBA · Lewiston, IDN33HXCopter Lease LLC Trustee · Albuquerque, NMN353RCN353rc LLC · Chelan, WAN3605Mann Peter D · Willows, CAN3803CState Of Colorado Department Of Public Safety · Lakewood, CON3804CState Of Colorado Department Of Public Safety · Lakewood, CON3XLNixon Helicopters LLC · Mentone, CAN4040PR & R Conner Aviation LLC · Conner, MTN406JPHeli-Works Flight Services LLC · Deer Lodge, MT
Back to AD 75-01-05