N602SW, cancelled Jul 17, 2024
Service difficulty reports · 362
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 = 'N602SW' AND deregistration_id = 'N602SW-2024-07-17' 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 = 'N602SW' AND deregistration_id = 'N602SW-2024-07-17' 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 SWAA2015120946893Fan · failedDIVERSION & DECLARED EMER, STRONG BURNING SMELL IN CABIN ROW 7 - 9. R & R RECIRC FAN IAW AMM.SDR SWAA2015110545789Light · inoperativeLEFT OVERWING EMER EXIT LIGHT ON LOWER SIDEWALL BULB INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2015110445739Light · inoperativeFORWARD LAVATORY EMER EXIT SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015102645336Casting · shearedRIGHT WING INBD GND SPOILER CASTING SHEARED AT FWD ATTACH FITTING. R & R CASTING IAW SRM.SDR SWAA2015091543891Roller · damagedDIVERSION & DECLARED EMER, LE FLAPS TRANSIT LIGHT ILLUMINATED ON TAKEOFF. FOUND NR 4 SLAT, INBD AUXILIARY TRACK ROLLER DAMAGED, CAUSING RESTRICTED MOVEMENT OF NR 4 SLAT. R & R ROLLER IAW MM.SDR SWAA2015052239929Engine · failedINFLIGHT SHUTDOWN & DECLARED EMER. NR 1 ENG FAILED AT 3000 AGL. PROCEEDED BY COMPRESSOR STALL ROLLED BACK. AFTER SHUTDOWN RED LIGHT EGT 950 DEGREE, COOLED IMMEDIATELY. R & R NR 1 ENG IAW MT.SDR SWAA2015040738188Skin · crackedL1 DOOR CRACKED AT LOWER HINGE BOX INTERIOR SKIN & VERTICAL FRAME. REPAIRED SKIN IAW EA.SDR SWAA2015032637879Cover · crackedL1 EMER EXIT LIGHT COVER CRACKED. R & R COVER IAW SIP.SDR SWAA2015032637878Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014121535029Access Panel · leakingDIVERSION, FLUID LEAK AT RT WING ACCESS PANEL DURING FLIGHT. R & R FULL PANEL 8817R IAW MM.SDR SWAA2014110433661Regulator · faultyAIR TURN BACK DURING CLIMB NR 1 ENG BLEED 0 PSI. PRESS WOULD NOT RETURN. R & R BLEED AIR REGULATOR IAW MM.SDR SWAA2014090931760Strap · crackedSTRAP CRACKED AT BS 344 RBL 40. REPAIRED STRAP IAW SRM.SDR SWAA2014082831391Light · inoperativeL1 DOOR EMER EXIT LIGHT INOPERATIVE. REPAIRED BULB IAW AMM.SDR SWAA2014082631265Frame · crackedFRAME AUXILIARY & OTBD CHORD CRACKED AT BS 727 STRINGER 18A RT AT LOWER FWD HOLE. R & R CHORD IAW EA.SDR SWAA2014082631264Frame · crackedFRAME AUXILIARY & OTBD CHORD CRACKED AT BS 727 STRINGER 18A LT FWD LOWER HOLE. R & R CHORD IAW EA.SDR SWAA2014082531186Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED. REPAIR AFT FLAP IAW SRM.SDR SWAA2014080630642Angle · corrodedAFT CARGO FLOOR SUPPORT CHANNEL CORRODED AT BS 727C+6.5 RBL 3.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430586Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 RBL 13. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430585Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 RBL 8.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430584Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 RBL 3.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430583Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 LBL 8.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430582Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 LBL 3. REPAIRED ANGLE IAW EA & SRM.SDR SWAA2014082031030Shear Tie · corrodedSHEAR TIE ANGLE CORRODED AT BS 727E STRINGER 27L. R & R ANGLE IAW SRM.SDR SWAA2014082031029Shear Tie · corrodedSHEAR TIE ANGLE CORRODED AT BS 727D STRINGER 27R. REPAIRED ANGLE IAW SRM & DWG.SDR SWAA2014081930996Shear Tie · corrodedAFT PIT FRAME SHEAR TIE CORRODED AT BS 727C BETWEEN STRINGER 26L TO 26R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014072830390Fairing · delaminatedLEFT WING OUTER TAB FAIRING DELAMINATED ON UPPER SURFACE. REPAIRED FAIRING IAW SRM.SDR SWAA2014081930995Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 727E STRINGER 26R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014080430581Angle · corrodedAFT CARGO FLOOR SUPPORT ANGLE CORRODED BETWEEN BS 727D TO 727E STRINGER 27R. REPAIRED ANGLE IAW EA.SDR SWAA2014082531185Stiffener · corrodedAFT PRESS BULKHEAD CHANNEL STIFFENERS CORRODED AT BS 1016 WL 208. REPAIRED STIFFENER IAW EA.SDR SWAA2014080830708Web · crackedNOSE LANDING GEAR WW WEB LT SIDE PANEL CRACKED AT BS 259. REPAIRED WEB IAW EA.SDR SWAA2014073030470Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 STRINGER 18L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014072530329Channel · crackedSPLICE CHANNEL CRACKED AT BS 360 STRINGER 15L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014081930994Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663 TO 668 RBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014073030469Intercostal · crackedINTERCOSTAL STRAP CRACKED AT BETWEEN BS 348 TO 351 STRINGER 16L. R & R INTERCOSTAL IAW SRM.SDR SWAA2014082731310Crossbeam · crackedC2 DOOR CROSSBEAM WEB CRACKED AT LOWER FASTENER. R & R C2 DOOR IAW MM.SDR SWAA2014082631263Frame · crackedFRAME AUXILIARY & OTBD CHORD CRACKED AT BS 727 STRINGER 18A RT LOWER FWD HOLE. R & R CHORD IAW EA.SDR SWAA2014082631255Structure · crackedOUTBOARD CHORD CRACKED AT BS 727 STRINGER 18A LT FWD LOWER HOLE. R & R CHORD IAW EA.SDR SWAA2014082531184Pressure Deck · crackedMAIN CABIN PRESS DECK BEADED WEB PANEL OVER MAIN WW CRACKED AT BS 673 LBL 42.50. REPAIRED WEB IAW EA.SDR SWAA2014082131079Door Frame · crackedR1 EMER EXIT DOOR FRAME CRACKED AT LOWER FWD EDGE WEB. REPAIRED FRAME IAW SRM.SDR SWAA2014081930993Floor Support · corrodedL1 DOOR ENTRY AREA UNDER FLOOR SUPPORT CORRODED AT BS 328 LBL 28. REPAIRED SUPPORT IAW SRM.SDR SWAA2014072830401Attach Bracket · crackedRIGHT WING NR 6 SLAT INBD MAIN TRACK COVER PLATE ATTACHING BRACKET CRACKED. R & R BRACKET IAW DWG.SDR SWAA2014060528717Slide · low pressureR2 DOOR EMER EVAC SLIDE PRESS LOW. R & R SLIDE IAW MT.SDR SWAA2014032026262Sign · looseFORWARD ENTRY DOOR LOWER EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR SWAA2014012724573Skin · delaminatedRT WING OTBD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013121323264Flap · out of positionR2 DOOR SLIDE LOWER FLAP OUT OF POSITION. REPOSITIONED R2 DOOR SLIDE LOWER FLAP IAW MT.SDR SWAA2013020112227Housing · defectiveMID CABIN EMERGENCY CABIN LIGHT INOP. REMOVED EMERGENCY CABIN LIGHT AND ACCESSED BATTERY PACK IAW SRM 51-40-02. REMOVED AND REPLACED BATTERY PACK HOUSING STA 603 LT. RE-INSTALLED EMERGENCY CABIN LIGHT IAW AMM TASK 33-51-51-962-016, OP CHECK GOOD.SDR SWAA2013012911993Wire · brokenAIR TURNBACK ON TAKEOFF, INITIAL CLIMB, LANDING GEAR LEVER WAS RAISED TO THE UP POSITION. ALL GREEN LIGHTS EXTINGUISHED, BUT THE RT MAIN GEAR RED LIGHT REMAINED ILLUMINATED. R & R WIRE IAW AMM.SDR SWAA2013012111610Stringer Splice · crackedRIGHT BS 727 PRODUCTION SPLICE STA 13 HAS CRACKED AT HOLE NR 4. REMOVED AND REPLACED SPLICE IAW BAC DWG.SDR SWAA2013012111609Doubler · puncturedSTA 266 O/B OF STR 2L INTERNAL DOUBLER HAS 1EA O/S HOLE. REPAIRED O/S HOLE AT STA 266 O/B OF STR 2L IN INTERNAL DOUBLER IAW REO G15826 REV IR AND EA 1-353-21488 REV - . FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013012111608Doubler · puncturedSTA 278 I/B OF STR 2R INTERNAL DOUBLER HAS 1EA O/S HOLE. REPAIRED O/S HOLE AT STA 278 I/B OF STR 2R IN INTERNAL DOUBLER IAW REO G15826 REV IR AND EA 1-353-21488 REV - .
Back to N602SW, cancelled Jul 17, 2024