N34137
Service difficulty reports · 70
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 = 'N34137' AND registry_match = 'registration' 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 = 'N34137' AND registry_match = 'registration' 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 CALA2017050501278Girt Bar · disconnectedDOOR 2L SLIDE LIGHT NOT ILLUMINATED AFTER ARMING DOOR. FOUND GIRT BAR DISCONNECTED. RECONNECTED GIRT BAR PER AMM 25-66-00. OPS CK GOOD.SDR CALA2017041400977Solenoid · faultyMOMENTARY N2 OVSPD NO 1 ENG DURING MAX EPR TAKEOFF. R&R LEFT SOLENOID ON NR 1 ENG IN REF TO AMM75-32-03-404 015-R04. REMOVED AND REPLACED RIGHT SOLENOID VALVE ON LEFT ENGINE IAW AMM 75-32-03-404-046-R04. PER FIM TASK 75-32-00-815-824-R06 ACCOMPLISHED RESISTASDR CALA2016070500411Regulator · unserviceableCREW STATED BEFORE THEY LEFT THEY HAD CREW O2 AT 1150, CURRENTLY AT FL 390 ABOUT 239 MILES FROM DESTINATION THEY WENT TO PERFORM THEIR O2 RUNDOWN CHECK AND NEITHER MASK WOULD INFLATE. CREW O2 QTY NOW SHOWS ZERO, BUT THEY DO NOT HAVE AN EICAS MSG. REMOVED O2 SDR CALA2016061000357Stringer Splice · damagedFOUND DAMAGE TO STR 21R BETWEEN STA 297 AND STA 310. REMOVED STR SPLICE. PERFORMED VISUAL INSPECTION TO ENSURE NO OTHER DAMAGE. REWORK OF STRING SPLICE FLANGE TO ORGINAL CONTOUR, COMPLIED WITH HFEC. FABRICATED REPAIR CHANNEL. INSTALLED REPAIR CHANNEL AND SSDR CALA2016053100335Governor · unserviceableRIGHT ENG DOES NOT PUT OUT COMMANDED THRUST AT CRUISE. -1.60 COMMANDED, 1.18 INDICATED. R & R FUEL FLOW GOVERNOR IAW MM 73-21-01-404-013-R04. OPERATIONS CHECK & LEAK CHECK NORMAL AT THIS TIME. PERFORMED OPERATIONS TEST 1, 2, 9, 10 & 11, ALL TESTED WITHIN LSDR CALA2014050900568Fuse · blownLEFT & RIGHT OVERWING EMER DOOR EXIT POINTER LIGHTS INOPERATIVE. TROUBLE SHOT IAW WDM 33-51-22. FOUND EMER LIGHTS PWR SUPPLY M10699 WITH A BLOWN FUSE. REPLACED SAME. SYS GND CHECKED GOOD IAW MM 33-51-00-715-039.SDR CALA2012110200737Frame · damagedFRAME DAMAGED AT BS 1340 S26L. REPAIRED IAW EC/RA 5310-04505.SDR CALA2012110200736Frame · damagedBS 1320, FRAME DAMAGED. REPAIRED IAW ECRA 5310-04508.SDR CALA2012110100708Frame · crackedFRAME CRACKED BS 1380. REPAIRED IAW EC/RA 5310-04506.SDR CALA2012092100623Power Supply · inoperativeEMERGENCY LIGHT ROW 30 TO ROW 40 INOPERATIVE. CHANGED ATA 3300 TO 3350. REPLACED POWER SUPPLY AND BATTERY IAW MM 33-51-04. SYS CK OK IAW MM 33-51-04.SDR CALA2011051300364Strap · brokenSUPPORT TASK: LOWER STRIP UNDER FLOOR LINE IS BROKEN AT LBL 25 STA 366.25 TO STA 377. REPAIR FLOOR STABILIZATION STRAP AT LBL 25, STA 365 TO STA 377 PER EC/RA 5310-05378. SEE WIP TASK FOR WORK PERFORMED.SDR CALA2011051200362Frame · crackedSUPPORT TASK - FWD FRAME IS CRACKED JUST O/B OF ELECTRIC MOTOR DRIVEN PUMP, 22 INCHES FROM FWD BULKHEAD, RT SIDE OF RT MLG WHEEL WELL MKD. CUT OUT DAMAGED AREA AND INSTALLED REPAIR ANGLES REF ECRA 5340- 01447.SDR CALA2011050900353Frame · cracked757-53-3-0370 FWD CARGO COMPT, STA 660 FRAME IS DENTED ON FLANGE AT AREA BETWEEN S23R - S24R. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLER REF SRM 53-30-07 REPAIR 5.SDR CALA2011050200329Frame · crackedCABIN PSU RAIL RT SIDE AT STA 1580, ATTACH BRACKET HAS CRACK MIGRATING FROM RIVET ON FRAME CUT DAMAGED SECTION , ASSEMBLED AND DRILLED REPAIR PARTS, TREATED, PRIMED, AND INSTALLED REPAIR PARTS REF SRM 53-00-07 REPAIR 1 AND SRM 51-40-02.SDR CALA2011042900325Floorbeam · damagedFLOORBEAM AT STA 1640 HAVE SCRIBE MARKED BETWEEN LBL 50 TO RBL 42; AS MARKED. CUT OUT DAMAGED AREA OF FLOORBEAM AT STA 1640, FABRICATED AND INSTALLED NEW FLOORBEAM REPAIR REF SRM 53-00-51 REPAIR.SDR CALA0700665Shade · burnedTHERE WAS A REPORT THAT THE WINDOW AREA AT THE LT FORWARD OVERWING EXIT GOT HOT ENOUGH TO SCORCH THE SHADE AND PILLOW AT THE PASSENGER SEAT. NO SMOKE, FIRE, OR ODOR WAS OBSERVED. THE LEFT OVERWING HATCH AREA WAS INSPECTED AND SOME BROWN DISCOLORATION WAS FOUNSDR CALA0600193Oven · malfunctionedTHE FLIGHT ATTENDANT REPORTED SMOKE COMING OUT OF THE TOP OF THE AFT GALLEY LEFT NR 1 OVEN DURING CLIMBOUT. BOTH UTILITY BUSSES WERE TURNED OFF AND THE AFT GALLEY OVEN CIRCUIT BREAKERS WERE PULLED. THE SMOKE DISSIPATED QUICKLY AND THE FLIGHT WAS CONTINUED WSDR CALA0500065Bottle · dischargedTHE L-4 DOOR ASSIST BOTTLE WAS FOUND TO HAVE ZERO PRESSURE. THE BOTTLE WAS REMOVED AND REPLACED IAW MM 52-11-30.SDR CALA0400284Battery · inoperativeTHE R-2 DOOR EMERGENCY LIGHTS WERE FOUND INOPERATIVE. A NEW BATTERY PACK WAS INSTALLED IAW MM 33-51-07.SDR CALA0400283Charger · inoperativeINSPECTION FOUND R-1 DOOR EMERGENCY LIGHTS INOPERATIVE. THE EMERGENCY LIGHT BATTERY CHARGER AT STA 340 (IN OVERHEAD AT FORWARD LAV & COCKPIT DOOR) WAS FOUND AT FAULT. THE CHARGER WAS REMOVED AND REPLACED IAW MM 33-51-07.
Back to N34137