AD 2002-03-52
Registered aircraft · 1,115
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:2002-03-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-52')
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:2002-03-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-52') 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.
N306LFAir Methods LLC · Greenwood Village, CON306MPMiami-Dade Sheriffs Office · Doral, FLN307MPMiami-Dade Sheriffs Office · Doral, FLN308ACBank Of Utah Trustee · Salt Lake City, UTN308MPMiami-Dade Sheriffs Office · Doral, FLN309MPMiami-Dade Sheriffs Office · Doral, FLN30EZHover Air LLC · Anchorage, AKFirst renewal noticeN30NTCity Of Ontario · Ontario, CAN310SWWings Air Helicopters LLC · West Harrison, NYN312BPatriot Aviation Inc · Greenville, DEN312SDHarris County Sheriffs Office · Spring, TXN316ELMercy Air Helicopter Inc · Fort Lauderdale, FLN317AMAir Methods LLC · Greenwood Village, CON318MGNs Air Leasing LLC · Wilmington, DEN31BHBrainerd Helicopters Inc · Leesburg, FLN31NSTemsco Helicopters Inc · Ketchikan, AKN320PANs Air Leasing LLC · Wilmington, DEN322AHSuperior Helicopter Services LLC · Indianapolis, INN322VDepartment Of Homeland Security · Washington, DCN323AHBristow LLC · Lake Charles, LAN323LAWestern Summit Enterprises Inc · Pacoima, CAN324BFRiverbend Enterprises Inc · Idaho Falls, IDN325AMAir Methods LLC · Greenwood Village, CON326PDCity Of Anaheim · Fullerton, CAN328CHAir Methods LLC · Greenwood Village, CON328HWSky High Leasing LLC · Montrose, CON329AMAir Methods LLC · Greenwood Village, CON329TXTexas Department Of Public Safety · Austin, TXN3320ADepartment Of Homeland Security · Washington, DCN332AMAir Methods LLC · Greenwood Village, CON334HFHaynes Aviation LLC · Wetumpka, ALN335AMAir Methods LLC · Greenwood Village, COFirst renewal noticeN336AMAir Methods LLC · Greenwood Village, CON337ACNs Air Leasing LLC · Wilmington, DEN338SDErie County Sheriffs Office · Buffalo, NYN338SFErie County · Buffalo, NYN339AMAir Methods LLC · Greenwood Village, CON339SDErie County Sheriffs Office · Buffalo, NYN340PMAllred Leasing LLC · Missoula, MTN341AMAir Methods LLC · Greenwood Village, CON341PPhi Health LLC · Tempe, AZN342RDepartment Of Homeland Security · Washington, DCN344AMFirst Citizens Bank & Trust Company · Morristown, NJN344BVRegistered 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, MT
Back to AD 2002-03-52