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.
N520MDChatham County Mosquito Control · Savannah, GAN520MGHagedorn Aviation · Columbus, OHN520MHSilver Cloud One LLC · Reno, NVN520NQuantumtrace Inc · Incline Village, NVN520NMWillard Development Inc · Port Saint Lucie, FLN520NTAurora Meridian LLC · Portland, ORN520PAMid Pacific Aero Services LLC · Honolulu, HIN520PDCity Of Glendale Police Department · Glendale, CAN520VCVolusia County Mosquito Control · New Smyrna Beach, FLN520WHWinco Inc · Aurora, ORN521PAPatriot Aviation Inc · Greenville, DEN521PDSale Reported · Costa Mesa, CASale reportedN521TCTre Aviation Corp · Wilmington, DEN5238CAviation Advantage Inc · Tabor City, NCN523CPHowe Aviation LLC · Surprise, AZN523HBCrg2 LLC · Lees Summit, MON5245PFlight Level Zero LLC · Othello, WAN5264QSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5277FCity Of Houston · Houston, TXN5278FCity Of Houston · Houston, TXN5279FCity Of Houston · Houston, TXN527FBChatham County Mosquito Control · Savannah, GAN527HKHawkeye Helicopter LLC · Lyndon, KSN5280FCity Of Houston · Houston, TXN5284FCity Of Houston · Houston, TXN5288XCollier Mosquito Control District · Naples, FLN52RDHelicopter Services West LLC · Benicia, CAN530Valiair Lc Trustee · Casper, WYN530ARN530mx LLC · Missoula, MTFirst renewal noticeN530CGSvp LLC · Tucson, AZN530DGHlh Leasing LLC · Wilmington, DEN530FCFerguson And Sons Construction · Emmett, IDN530FFUtah Aviation Services Inc · Spanish Fork, UTN530FMGooseneck Inc · Heber City, UTN530HBKansas Farm & Ranch Inc · Seneca, KSN530JLLas Vegas Metropolitan Police Department · Las Vegas, NVN530JRApex Heli-Support LLC · Phoenix, AZN530MPRegistration Pending · Missoula, MTRegistration pendingN530RLGulf Helicopters LLC · Santa Fe, TXN530RPGilliam Aviation LLC · Odessa, TXN530STJ&J Holdings And Investments LLC · Phoenix, AZN530TGSummit Helicopter Inc · Pacoima, CAN530THHeliservice LLC · Wilmington, DEN530TTAdvanced Aerospace Consultants Inc · Boynton Beach, FLN530TVTennessee Valley Authority · Muscle Shoals, ALN530VHSvp LLC · Missoula, MTN530WHWinco Inc · Aurora, ORN530XOxford Police Department · Oxford, ALN530XXFerguson And Sons Construction LLC · Emmett, IDN5313YSeley Corp · Ketchikan, AK
Back to AD 2000-25-52