AD 2012-25-01
Registered aircraft · 954
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-25-01')
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-25-01')
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-25-01') 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-25-01') 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.
N339SDErie County Sheriffs Office · Buffalo, NYN340PMAllred Leasing LLC · Missoula, MTN341PPhi Health LLC · Tempe, AZN342RDepartment Of Homeland Security · Washington, DCN344BVRegistered aircraftN345HEAircraft Guaranty Corp Trustee · Oklahoma City, OKN348ACBank Of Utah Trustee · Salt Lake City, UTN348PPhi Health LLC · Tempe, AZN349PAPathfinder Leasing LLC · Anchorage, AKN34CMNewcomer Christopher · Navasota, TXN34HXPolar Star Corp · Kalispell, MTN34MBN1079a LLC · Missoula, MTN350AMAir Methods LLC · Greenwood Village, CON350BAEuro Tec Vertical Flight Solutions LLC · Eudora, KSN350DHGuardian Flight Holdings Inc · Fairbanks, AKN350DLSierra Group LLC · Bend, ORN350FSDiscovery Helicopters LLC · Las Vegas, NVN350GYAir Services International Leasing LLC · Fort Lauderdale, FLN350HAHillsboro Aviation Inc · Hillsboro, ORN350HDT Scott Dunn Construction Inc · Phoenix, ORN350HFTrans Aero LLC · Cheyenne, WYN350HMIndiana Helicopters LLC · Fort Wayne, INN350HQNs Air Leasing LLC · Wilmington, DEN350LFAir Methods LLC · Greenwood Village, CON350LPAirman Helicopter Inc · Fort Lauderdale, FLN350MALabutte Air Inc · Flint, MIFirst renewal noticeN350MPCity Of Memphis Police Department · Memphis, TNN350MSMississippi Department Of Public Safety · Jackson, MSN350MVAir Methods LLC · Greenwood Village, CON350MWMountain West Helicopters LLC · Saratoga Springs, UTN350NCState Of North Carolina · Raleigh, NCN350NTNorth Texas Helicopters Inc · Newark, TXN350PAircraft Trustee Service Inc Trustee · Dover, DEN350PSSofie Enterprises Inc · Wilmington, DEN350PWTexas Parks & Wildlife Dept · Austin, TXN350RAirwest Helicopters Inc · Redlands, CAN350RFZirkle Aviation LLC · Selah, WAN350RNGazelle LLC · Henderson, NVN350SGRunway Group LLC · Bentonville, ARN350SHJc Aircraft Leasing LLC · Wasilla, AKN350TARoberts Aircraft LLC · Cheyenne, WYN350TLSpurr Mountain Aviation Inc · New York, NYN350UKInternational Air Services Inc Owner Trustee · Carson City, NVN350UMUniversity Of Miami · Miami, FLN350VRPrecision LLC · Mcminnville, ORN350XDInternational Air Services Inc Trustee · Carson City, NVN350ZFCactus West LLC · Clovis, NMN351CHSycan Corp DBA Sinton Helicopters · Paso Robles, CAN351EReeder Flying Service Inc · Twin Falls, IDN351FSDiscovery Helicopters LLC · Las Vegas, NV
Back to AD 2012-25-01