N910HA, cancelled Apr 9, 2013
Service difficulty reports · 19
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N910HA' AND deregistration_id = 'N910HA-2013-04-09' ORDER BY difficulty_date DESC"
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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N910HA' AND deregistration_id = 'N910HA-2013-04-09' ORDER BY difficulty_date DESC
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.
SDR HNAA0200031Strut · crackedDURING ROUTINE INSPECTION FOUND #2 ENGINE AFT OUTBOARD ENGINE MOUNT VERTICAL STRUT CRACKED AT THE HORIZONTAL STRUT ATTACH POINT. REPLACED VERTICAL STRUT.SDR HNAA0100033Controller · faultyON DEPARTURE FROM LGA, AUTO PILOT ENGAGED WITHOUT COMMAND. AFTER CANCELLING AUTO PILOT REMAINS ILLUMINATED BOTH YAW DAMPER CARROTT AND HSI CARROTT REMAIN ON. REMOVED AND REPLACED FGC CONTROLLER.SDR HNAA010032Selector Valve · failedTHE GEAR WOULD NOT EXTEND WHEN SELECTED DOWN. CREW PERFORMED ALTERNATE EXTENSION. REPLACED LANDING GEAR SELECTOR VALVE.SDR HNAA0000021Power Supply · inoperativeOVERHEAD EMERGENCY LIGHT WAS INOP. REPLACED BATTERY POWER SUPPLY 3351PS3.SDR HNAA9900111Battery · dischargedNR 3 AND NR 4 RED FLOOR ESCAPE LTS INOP. REMOVED AND REPLACED LEFT AFT EMERGENCY LT BATTERY AND BASE. OPS CHECK GOOD.SDR HNAA9900064Light · shortedFLOOR ESCAPE PATH LIGHTS WENT OFF, APU FAILURE. REMOVED AND REPLACED 3352-P1 BASE, OPS CHECK GOOD.SDR HNAA9900059Battery Pack · dischargedDURING OVERNIGHT, MAINTENANCE IT WAS FOUND THAT THE LT OUTSIDE EMERGENCY LIGHT DID NOT ILLUMINATE. THE PS3 BATTERY PACK WAS REPLACED.SDR HNAA9891062Skin · damagedSBY - BAGGAGE DOOR SKIN FOUND DAMAGED ON TOP AFT CORNER IN TWO PLACES. REPAIRED IAW PIEDMONT AIRLINES E08-52-98-1025. (M)SDR HNAA9891047Lock Assy · failedFLT 3162 - GSO-DCA - COCKPIT DOOR DOES NOT OPEN, LATCH ASSY INTERMITTENTLY STICKS. INSPECTED DOOR LATCH ASSY AND STRIKER PLATE FOR DEFECTS, NONE FOUND. COULD NOT DUPLICATE. (M)SDR HNAA9891037Acm · failedFLT 3019 - CRW-DCA - NOXIOUS FUMES COMING FROM AIR CONDITIONING SYSTEM DURING FLIGHT. REMOVED AND REPLACED ACM AND HEAT EXCHANGER. OPS AND LEAK CHECK GOOD. (M)SDR 98ZZZM713Heat Exchanger · failedFLT 3019 - CRW-DCA - NOXIOUS FUMES COMING FROM AIR CONDITIONING SYSTEM DURING FLIGHT. REMOVED AND REPLACED ACM AND HEAT EXCHANGER. OPS AND LEAK CHECK GOOD. (M)SDR HNAA9791004Unloading Valve · failedFLT 3338 - ORF-DCA - PARTIAL LOSS OF HYDRAULIC FLUID IN NR 2 SYSTEM ON APPROACH TO DCA. THE AIRCRAFT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED THE NR 2 SPOILER UNLOADING VALVE. (M)SDR HNAA9691036Battery Pack · dischargedFLT 3040 - FLL-TPA - DURING PREFLIGHT CHECKS, FOUND THE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED EMERGENCY BATTERY PACK. (M)SDR 95ZZZX6293Gear Light · illuminatedEYW/MIA - FLT 3298 - THE NOSE GEAR UNSAFE LIGHT CAME ON IN-FLIGHT. THE NOSE GEAR CYCLED SEVERAL TIMES. THE AIRCRAFT CONTINUED ON TO MIA AND LANDED WITHOUT INCIDENT. CLEANED AND INSPECTED NOSE GEAR DOWNLOCK/UPLOCK SENSOR AND WIRING. CHECKED GAP ON SENSOR, NSDR 95ZZZX2490Valve Actuator · failedYYZ/BWI - FLT 3393 - THE NR 2 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED, FOLLOWED BY LOSS OF OIL PRESSURE ON THE NR 2 ENGINE OIL PRESSURE GAUGE. POWER WAS REDUCED IMMEDIATELY AND THE ENGINE WAS SHUT DOWN IN-FLIGHT. AIRCRAFT DIVERTED TO SCE AND LANDED WITSDR 95ZZZX2489Valve · failedYYZ/BWI - FLT 3393 - THE NR 2 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED, FOLLOWED BY LOSS OF OIL PRESSURE ON THE NR 2 ENGINE OIL PRESSURE GAUGE. POWER WAS REDUCED IMMEDIATELY AND THE ENGINE WAS SHUT DOWN IN-FLIGHT. AIRCRAFT DIVERTED TO SCE AND LANDED WITSDR 95ZZZX2488Oil Cooler · failedYYZ/BWI - FLT 3393 - THE NR 2 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED, FOLLOWED BY LOSS OF OIL PRESSURE ON THE NR 2 ENGINE OIL PRESSURE GAUGE. POWER WAS REDUCED IMMEDIATELY AND THE ENGINE WAS SHUT DOWN IN-FLIGHT. AIRCRAFT DIVERTED TO SCE AND LANDED WITSDR 95ZZZZ98Eel Battery Pack · failedFLT 3205 - HHH-CLT - EMERGENCY EXIT SIGN OVER FORWARD RIGHT EMERGENCY EXIT DOOR AND FORWARD OVERHEAD EMERGENCY FLOOR LIGHT DOES NOT TEST DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK IN 3351P2 POSITION. REFERENCE NR 95ZZZZ97.SDR 95ZZZZ97Eel Power Supply · failedFLT 3205 - HHH-CLT - EMERGENCY EXIT SIGN OVER FORWARD RIGHT EMERGENCY EXIT DOOR AND FORWARD OVERHEAD EMERGENCY FLOOR LIGHT DOES NOT TEST DURING PREFLIGHT CHECK. REMOVED AND REPLACED POWER SUPPLY AND BATTERY PACK IN 3351P2 POSITION. REFERENCE NR 95ZZZZ98.
Back to N910HA, cancelled Apr 9, 2013