AD 2000-25-52
Registered aircraft · 649
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:2000-25-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:2000-25-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:2000-25-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:2000-25-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.
N18GHCity And County Of Honolulu · Honolulu, HIN193VSVertol Systems Co Inc · Destin, FLN195VSVertol Systems Co Inc · Destin, FLN199FFHeavy Lift Helicopters Inc · Fresno, CAN19FFHeliservice LLC · Wilmington, DEN2091RCity Of El Paso Police Department · El Paso, TXN20ATFlight Trails Helicopters Inc · Mesa, AZN20FLLocker Fred · Muleshoe, TXN212ELMark Mondo Building & Excavating Inc · Reno, OHN212VTLaroche Aviation Services LLC · Bellaire, OHN215MBunn Mary E · Williamstown, WVN21772N21772 LLC · Wellington, FLN220PDCity Of Oakland · Oakland, CAN221TGCollier Mosquito Control District · Naples, FLN225HRHeliwild Investments LLC · Austin, TXN228KKKeagy Ken · Central Point, ORN229HLAviation Advantage Inc · Tabor City, NCN230MDAir2 LLC · Blountville, TNN234RFMhoc LLC · Pensacola, FLN240FLAir2 LLC · Blountville, TNN241JHChatham County Mosquito Control · Savannah, GAN259BKCavanaugh Collections Inc · Addison, TXN262SDCullman Police Department · Cullman, ALN262WAWindward Aviation Inc · Puunene, HIN278KCCullman Police Dept · Cullman, ALN28MLTre Aviation Corp · Wilmington, DEN297ECounty Of Kern · Bakersfield, CAN298JWHeliservice LLC · Wilmington, DEN298PPGillespie Flying Services LLC · Trenton, SCN298SDCsw LLC · Anacoco, LAN299DRKings County Sheriffs Office · Hanford, CAN301HFCity And County Of Honolulu · Honolulu, HIN301SDHarrison County Sheriffs Department · Gulfport, MSN302HFCity And County Of Honolulu · Honolulu, HIN303HFHonolulu Fire Department · Honolulu, HIN3051QCharlie Helicopter Company LLC · Sierra Blanca, TXN305AZJta Express Inc · Wilmington, DEN305JEDah Aircraft LLC · Georgetown, SCN307APMg Holdings LLC · Alpine, WYN311VTGeco Inc · Wilmington, DEN3121QC&D Helicopters LLC · Spanish Fork, UTN313JPPerell John · Miami Beach, FLN315SHJc Aircraft Leasing LLC · Wasilla, AKN316HKHawkeye Holdings LLC · Lyndon, KSN31HMDah Aircraft LLC · Georgetown, SCN321PERadnor Construction Of Delaware Inc · Allentown, PAN330CMDewind Helicopter Services LLC · Zeeland, MIN331WHSchreindl Lawrence A · Colton, ORN332ABUsda Aphis Ws Atoc · Cedar City, UTN333TABallard Aviation Inc · Newton, KS
Back to AD 2000-25-52