N17139
Service difficulty reports · 71
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 = 'N17139' 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 = 'N17139' 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 CALA2014042200485Terminal · looseLEFT ROW 25 AISLE EMERGENCY LIGHT INOPERATIVE. TROUBLESHOOTING FOUND LOOSE TERMINAL END AT LIGHT ASSEMBLY, SECURED TERMINAL IAW AMM 33-51-05 & TESTED NORMAL IAW AMM 33-51-00.SDR CALA2014042200484Light · inoperativeR3 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R LAMP R3 DOOR EMERGENCY LIGHT IAW AMM 33-51-06 & TESTED NORMAL.SDR CALA2014042100479Frame · dentedFOUND DENT AT AFT CARGO COMPARTMENT FRAME STATION 1260 STRINGER 25L - STRINGER 26L. CUT OUT DENT & REPAIRED IAW SRM 53-00-07 REPAIR 5.SDR CALA2014042100478Frame · dentedDENT FOUND AT FRAME STATION 1320 APPROX STRINGER 26R - 25R AFT CARGO COMPARTMENT. CUT OUT DENT & REPAIRED IAW SRM 53-00-07 REPAIR 5.SDR CALA2014042100477Frame · dentedFOUND DENT AT FWD CARGO COMPARTMENT FRAME STATION 680, APPROX STRINGER 24R - STR 25R. CUT OUT DENT & REPAIRED IAW SRM 53-00-07 REPAIR 5.SDR CALA2013082300587Tpu · malfunctionedRIGHT ENGINE FAILED DURING APPROACH. OIL PRESSURE WENT TO ZERO. RT ENGINE LP PUMP STATUS MESSAGE COMPLIED WITH IFSD FIM 71-00-00-815-806-R-00. REPLACED PLA TRANSDUCER DUE TO NO ENGINE REPORT DATA. REPLACED TPU, REF LP 4708645. BOROSCOPED HP IP & LP COMPRESSORSDR CALA2011061000429Angle · corrodedSUPPORT TASK A/B/B LOWER SILL OUTER CHORD JUST FWD OF STA 1380 HAS CORROSION ON VERTICAL LEG. PERFORMED REPAIR TO A/B/B LOWER SILL OUTER CHORD JUST FWD OF STA 1380 COMPLYING WITH ALL STEPS 1-11 OF EC/RA 5310-05384 AND INITIATED A DIP 11189 TO READ ACCOMPLISH SDR CALA2011053100400Skin · damagedA DISCREPANT HOLE NR 40 EXISTS AT STA 1300, STR 21L UNDER L CLIP, WING TO BODY STRUCTURE. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLER, INITIATED DIP WITH THIS LOG PAGE 9943009 FOR NDT INSPECTION REQUIRED THRESHOLD 37500 FLIGHT CYCLES AT INTERVALS SDR CALA2011052700398Floorbeam · corrodedPAX FLOORBEAM STA 1640 HEAVY CORROSION FROM LBL 9 -RBL 9. REPAIRED FLOORBEAM REF SRM 53-00-51 REPAIR 3.SDR CALA2011052700397Floorbeam · corrodedFLOORBEAM CORRODED STA 1660 BL 0. REPAIRED FLOORBEAM REF SRM 53-00-51 REPAIR 3.SDR CALA2011052600393Frame · cracked757-3-0446:CABIN FRAME CRACKED STA 1580 BETWEEN S8R AND S9R. REPAIR CRACKED FRAME AT STA 1580 BETWEEN S8R AND S9R. REF SRM 53 -00-07 REPAIR 1. ISSUED DIP FOR REP DVI INSP. CABIN FRAME CRACKED STA 1580,STR 8RT & 9RT. PER SRM 53-00-07, REPAIR 1,ZONE 2, COMPSDR CALA2011052400391Beam · corroded757-53-0007 PAX FLOOR , STA 1660 LBL 48 HAS CORROSION. COMPLETED REPAIR AREA ON PAX FLOOR STA 1660 LBL 48 REF SRM 53-60-51 AND SRM 53-00-51 FOR WORK PERFORMED SEE WIPS.SDR CALA2011052300386Floorbeam · corroded757-53-3-0007 PAX FLOORBEAM F STA 1620 HEAVY CORROSION FROM LBL 4 TO RBL 9. INSTALLED REPAIR T CHORD ON FLOORBEAM AT STA 1620 REF SRM 53-00-51 FIG 201.SDR CALA2011022200104Unknown · odorDURING CLIMBOUT PASSING APPROX 33,000 FT 45 MIN INTO FLT, CABIN CREW AND PAX REPORTED STRONG BURNT ELECTRICAL ODOR BETWEEN ROW 20-23. C/W QRH PROCEDURES AND LANDED IN BOS. LANDING WAS NORMAL. LANDING WT=224,000 LBS. PERF 757 AMM TASK 05-58-910-801 SMOKE IN SDR CALA2010052000219Oven · overheatedFIRST CLASS OVEN 205 OVERHEATED AND THE COILS WERE BRIGHT RED. THERE WAS AN ELECTRICAL SMELL AND THE FLIGHT ATTENDANT TURNED THE OVEN OFF AND PULLED IT'S CIRCUIT BREAKER. ACCOMPLISHED AM PROCEDURE 05-51-58. OVEN DEFERRED. REPLACED OVEN NR 205. CHECKS OK. SDR CALA2009091700554Coffeemaker · defectiveFORWARD GALLEY - ON INITIAL TURN-ON, F/A HEARD LOUD POP, SAW SMOKE AND NOTICED A BURNING SMELL. INSPECTED FORWARD GALLEY FOR SMOKE (PER FORM 46-6020) - FOUND NR 2 COFFEEMAKER HAD A BROKEN / BURNT HEATING ELEMENT. REMOVED AND REPLACED COFFEEMAKER, BREWED A POSDR CALA0800532Frame · gougedBULKHEAD GOUGED FROM FWD ACCESSORY DOOR (113AL) LATCH HITTING PART STATION 231 BL 0. PERFORMED REPAIR TO FRAME AT STATION 231 BL 0 PER EC/RA 5311-01407.SDR CALA0600375Oven · inoperativeSMOKE BEGAN COMING FROM THE NR 1 AFT GALLEY OVEN WHILE EN ROUTE TO LGW. THE OVEN CIRCUIT BREAKER WAS PULLED AND THE SMOKE CEASED. THE FLIGHT CONTINUED TO LGW WHERE IT LANDED SAFELY WITHOUT FURTHER INCIDENT. THE OVEN AND CONTROLLER WERE REMOVED AND REPLACED SDR CALA0600041Skin · corrodedTHE LOWER FUSELAGE SKIN WAS FOUND CORRODED UNDER AIRFONE ANTENNA WITH A DENT AT STA 1510, LBL 4. A PERMANENT REPAIR WAS INSTALLED USING A DOUBLER IAW ECRA 5330-03521.SDR CALA0500315Wire · strippedINSPECTION FOUND EMERGENCY AISLE PATH LIGHTING INOPERATIVE AT ROWS 7-20. A POWER WIRE AT ROW 24 WAS FOUND STRIPPED. THE WIRE WAS SPLICED AND THE LIGHTING CHECKED GOOD.SDR CALA0400583Skin · corrodedINSPECTION FOUND SKIN UNDER RT AIRPHONE ANTENNA CORRODED AT STA 1440, S29R. A SKIN REPAIR WAS INSTALLED IAW SRM 53-00-01, FIGURE 204.
Back to N17139