N613SW, cancelled Jan 2, 2019
Service difficulty reports · 268
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 = 'N613SW' AND deregistration_id = 'N613SW-2019-01-02' 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 = 'N613SW' AND deregistration_id = 'N613SW-2019-01-02' 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 SWAA086139Fitting · looseDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR SLIDE GIRT BAR FWD CLIP LOOSE. SECURED CLIP PER MM.SDR SWAA082882Lens · looseBULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 6 ABC. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA081299Lens · crackedEEPLS LENS CRACKED AT ROW 6 ABC. REMOVED AND REPLACED LENS PER MM.SDR SWAA075373Lamp · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075332Lamp · inoperativeDURING SCHEDULED BRDG CHECK, FOUND RT FWD FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075136Flap · delaminatedDURING SCHEDULED BRDG CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REPAIRED FLAP PER SRM.SDR SWAA073985Slide · low pressureDURING SCHEDULED MV1 CHECK, R1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA071997Bearing · wornDURING SCHEDULED C4 CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED INPUT ROD BEARING PER MM.SDR SWAA064692Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT BS 846, STR 18R. REPAIRED WEB SECTION PER SRM.SDR SWAA064691Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 358, STR 16L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064606Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063982Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA063434Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT E&E COOLING EXHAUST DUCT CUTOUT, BS 378.5, LBL 2.8. REPAIRED SKIN PER SWA EA.SDR SWAA063433Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING INBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED INBOARD FORE FLAP PER MM.SDR SWAA062088Lens · missingFWD RIGHT EMERGENCY EXIT LIGHT LEFT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR SWAA062005Skin · crackedDURING SCHEDULED C1 CHECK, FOUND KEEL BEAM PANEL SKIN CRACKED AT BS 690, WL 148.5. REPAIRED SKIN PER SRM.SDR SWAA062004Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061487Light · inoperativeDURING SCHEDULED A2 CHECK, FOUND FWD RT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA061184Pump · fodAIR TURNBACK. ENGINE DRIVEN PUMP -A- SYSTEM HYDRAULIC QUANTITY DROPPED TO 1/4 FULL. FOUND NR 1 ENGINE DRIVEN HYDRAULIC PUMP CONTAMINATED WITH METAL. REMOVED AND REPLACED PUMP PER MM.SDR SWAA061164Hydraulic Line · leakingAIR TURNBACK, ENGINE DRIVEN "A" SYSTEM HYDRAULIC LOW PRESSURE LIGHT ILLUMINATED. "A" SYSTEM QUANTITY DROPPED TO 1/4 FULL. R&R "A" SYSTEM HYDRAULIC ELECTRIC DRIVEN PUMP PRESSURE LINE PER MM.SDR SWAA053737Hinge Fitting · crackedDURING SCHEDULED C3 CHECK, FOUND L1 DOOR LOWER FUSELAGE HINGE BOX FITTING CRACKED. REMOVED AND REPLACED HINGE BOX FITTING PER SRM.SDR SWAA052359Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 & L2 DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA052345Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052344Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R TO STR 26R. REPAIRED FRAME PER BFG ER.SDR SWAA052109Strap · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN STRAP CRACKED AT BS 440, STR 24R. REMOVED AND REPLACED SKIN STRAP SECTION PER SRM.SDR SWAA052100Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052099Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052072Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052071Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380 TO BS 400, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052098Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD & AFT FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED ATTACH BRACKETS PER SRM.SDR SWAA052097Floor Support · corrodedDURING SCHEDULED D-CHECK, FOUND CABIN LONGITUDINAL UPPER CHORD CORRODED AT BS 270, BL 0, WL 208. REPAIRED UPPER CHORD PER SRM.SDR SWAA052096Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOORBEAM UPPER CHORD CORRODED AT BS 259.5, LBL 6 TO RBL 11. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA052075Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986, LBL 45 TO RBL 45. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA052074Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 65 & RBL 65, WL 200. REPAIRED FRAME PER BFG ER.SDR SWAA052073Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT VERTICAL STAB ATTACH FITTING FWD & AFT PRIMARY CLEVIS LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA052070Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, LBL 17. REPAIRED FRAME PER SRM.SDR SWAA052069Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, BETWEEN LBL 6 TO RBL 6. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA052068Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA052067Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA052066Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052051Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 1064, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA043733Strip · wornDURING SCHEDULED C4 CHECK, FOUND EEPLS STRIP WORN AT ROWS 1 ABC & 3 ABC. REMOVED AND REPLACED EEPLS STRIPS PER MM.SDR SWAA043732Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING INBOARD T/E FORE FLAP DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA041653Flashlight · inoperativeDURING SCHEDULED C2 CHECK, FOUND AFT LOWER EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA041287Window · arcedIN FLIGHT THE R2 WINDOW ARCED, COMPLIED WITH QRH. REMOVED AND REPLACED R2 WINDOW PER MM.SDR SWAA041281Slide · dislodgedDURING SCHEDULED RON, L1 DOOR EVAC SLIDE FELL OUT OF CONTAINER, SLIDE DID NOT DEPLOY. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA041188Slide · out of positionL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040369Slide · looseR1 DOOR EVAC SLIDE LOOSE. RE-INSTALLED R1 DOOR EVAC SLIDE PER MM.SDR SWAA031334Battery · dischargedAFT CABIN EMERGENCY FLASHLIGHT BATTERY WEAK. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA030390Rib · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN S2R & S3R. REPAIRED RIB PER SWA EA.
Back to N613SW, cancelled Jan 2, 2019