N368SW, cancelled Mar 22, 2018
Service difficulty reports · 360
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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 SWAA2012112609801Support Channel · corrodedCORROSION ON LOWER SUPPORT CHANNEL LOCATED RIGHT EMERGENCY EXIT HATCH ESCAPE. REPLACED SUPPORT CHANNEL LOCATED RIGHT EMERGENCY EXIT HATCH ESCAPE IAW B737-300 SRM 51-10-02 ITEM 8, 51-40-02 AND DRAWING #65C3586.SDR SWAA2012111509493Skin · crackedCRACK ON GROUND AIR CONDITIONING ACCESS DOOR SKIN CUTOUT LOCATED AT BS 527 AND AT LEVEL OF STR 28R LOWER LOBE FUSELAGE. REPAIRED SKIN IAW EA.SDR SWAA2012111409322Fitting · crackedCRACK ON CLIP LOCATED FWD UPPER EDGE OF RIGHT EMERGENCY EXIT HATCH ESCAPE. REPLACED CLIP LOCATED FWD UPPER EDGE OF RIGHT EMERGENCY EXIT HATCH ESCAPE IAW B737-300 SRM 21-40-02 AND DRAWING.SDR SWAA2012101108421Carriage · corrodedLEFT WING NR 2 SPINDLE CARRIAGE ASSY CORRODED. REMOVED AND REPLACED NR 2 FLAP CARRIAGE ASSY IAW MT.SDR SWAA2012101108418Spindle · corrodedRIGHT WING NR 8 SPINDLE CORRODED. REMOVED AND REPLACED NR 8 FLAP CARRIAGE SPINDLE ASSY IAW MT.SDR SWAA2012072306119Fire Warning · faultyWHILE AT CRUISE (FL300) NR 2 ENGINE FIRE WARNING HANDLE ILLUMINATED MOMENTARILY. ALL ENGINE INDICATIONS NORMAL. REMOVED AND REPLACED FIRE DETECTION UNIT PER ICT.SDR SWAA2012072006041Fire Loop · out of positionNR 2 ENGINE FIRE LIGHT FLICKERED ON TWICE. BELL RANG AND ALL ASSOCIATED FAULT LIGHTS ILLUMINATED, STAYED ON FOR 2-3 SEC THEN WENT OUT. ALL ENGINE INSTRUMENTS WERE NORMAL EXCEPT NR 2 VIB GAUGE, IT FLUCTUATED BETWEEN .5-1.5 UNITS. INSPECTED FAN & CORE FIRE DESDR SWAA2012070905595Skin · crackedFUSELAGE SKIN CRACKED AT BS 370 + 4, STR 8L. REPAIRED SKIN IAW EA.SDR SWAA2012070305524Skin · crackedSKIN CRACKED AT BS 370+4, STR 8L. REPAIRED SKIN IAW SRM.SDR SWAA2012061204861Flap · delaminatedRIGHT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER AMM.SDR SWAA2012032802629Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER M/M & MT.SDR SWAA2012030601945Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT BS 616, RBL 60. REMOVED AND REPLACED CHORD IAW SRM.SDR SWAA2012022401681Lens · looseRT OVERWING EMERGENCY EXIT LIGHT LOOSE. SECURED LENS PER AMMSDR SWAA120352Light · brokenFWD ENTRY EMERGENCY EXIT LIGHT BULKHEAD LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA118166Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA115521Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA115326Lens · looseRT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER IAW MM.SDR SWAA115318Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 436, STR 1L. REPAIRED SKIN PER EA.SDR SWAA2014032826599Skin · crackedFUSELAGE SKIN CRACKED AT STATION 436, STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA113033Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA113032Window Post · crackedDURING SCHEDULED HC2 CHECK, FOUND CAPTAINS WINDOW POST SKIN CRACKED AT UPPER LT CORNER. REPAIRED WINDOW POST PER SRM.SDR SWAA110877Doubler · crackedDURING SCHEDULED 18Y CHECK, FOUND DOULBER CRACKED AT BS 360, BETWEEN STR 27L TO STR 28R. REPAIRED DOUBLER PER SRM.SDR SWAA110876Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 378, LBL 3. REPAIRED SKIN PER EA.SDR SWAA110546Tab · crackedDURING SCHEDULED 18Y CHECK, FOUND RT WING AILERON TAB CRACKED AT NOSE CAP SKIN. REMOVED AND REPLACED AILERON TAB PER MM.SDR SWAA110545Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA110521Mount Bracket · brokenDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE MOUNTING BRACKET BROKEN. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA110520Skin · puncturedDURING SCHEDULED 18Y CHECK, FOUND LT WING I/B TRAILING EDGE FORE FLAP LOWER SKIN PUNCTURED. REPAIRED FORE FLAP PER SRM.SDR SWAA110519Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND RT DOOR CREASE BREAM CORRODED BETWEEN BS 956 TO BS 986. REMOVED AND REPLACED CREASE BEAM PER SRM AND BAC DWG.SDR SWAA110502Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 20L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107942Lens · looseL1 DOOR EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA105423Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 423, STR 1. REPAIRED SKIN PER ER AND EA.SDR SWAA105218Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 423, STR 1. REPAIRED SKIN PER ER.SDR SWAA105217Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 413, STR 1. REPAIRED SKIN PER ER.SDR SWAA104263Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA102569Flap · delaminatedDURING SCHEDULED MV2 CHECK FOUND, RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA102170Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 990, STR 22R. REPAIRED SKIN PER ER.SDR SWAA102169Spar · corrodedDURING SCHEDULED OTS CHECK, FOUND RT HORIZONTAL STABILIZER REAR SPAR UPPER CHORD CORRODED. REPAIRED CHORD PER SRM.SDR SWAA102010Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 1006, STR 22R. REPAIRED FRAME PER SRM.SDR SWAA101502Stringer · crackedDURING SCHEDULED MV1 CHECK, FOUND STRINGER CRACKED AT BS 927, STR 22R. REPAIRED STRINGER PER EA.SDR SWAA101501Stringer · crackedDURING SCHEDULED MV1 CHECK, FOUND STRINGER CRACKED AT BS 907, STR 21R. REPAIRED STRINGER PER EA.SDR SWAA101017Wedge · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 5 SLAT T/E WEDGE O/B EDGE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA097993Light · looseRIGHT EEPLS LOOSE BETWEEN ROW 7 TO ROW 8. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA097548Cover · brokenDURING SCHEDULED MV2 CHECK, FOUND LT OVERWING EEPLS COVER BROKEN. REMOVED AND REPLACED COVER PER MM.SDR SWAA095942Lens · looseLT WING OVERWING EMERGENCY EXIT SIGN LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA095890Shutoff Valve · leakingAIR TURNBACK - HYD A-SYS FAILURE FOLLOWED BY LOW PRESS LIGHT INDICATION AND LOSS OF HYDRAULIC FLUID. REMOVED AND REPLACED FLIGHT CONTROL SHUT OFF VALVE MODULE DUE TO LEAK PER MM.SDR SWAA095876Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA095635Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER ASSY PER MM.SDR SWAA094912Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 19. RELAMPED PER MM.SDR SWAA094554Door · out of adjustDECLARED EMERGENCY. DURING CRUISE AT FL 350 HEARD 3 LOUD BUMPS. CABIN PRESSURE WAS NOTED CLIMBING AT 2000FT PER MINUTE. PACKS WERE PUT INTO HIGH AND DESCENDED AIRCRAFT AT 3000 FPM THIS KEPT CABIN FROM CLIMBING. PACKS IN AUTO MAINTAINED PRESSURE. PRESSURISDR SWAA094429Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.
Back to N368SW, cancelled Mar 22, 2018