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 SWAA2015042839065Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 226. REPAIRED CHORD IAW ER & EA.SDR SWAA2015032337680Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 597, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2015031737553Strap · deterioratedLEFT OVERWING EMER EXIT HATCH ESCAPE STRAP HOOK TOW COVER HAD DETERIORATED VELCRO. R & R STRAP ASSEMBLY IAW AMM.SDR SWAA2015031737552Strap · deterioratedRIGHT OVERWING EMER EXIT HATCH ESCAPE STRAP HOOK TOW COVER HAD DETERIORATED VELCRO. R & R STRAP ASSEMBLY IAW AMM.SDR SWAA0100020136503Cover · brokenL1 DOOR EMER EXIT LIGHT COVER BROKEN. R & R COVER IAW SIP.SDR SWAA2015020336286Spoiler · brokenLEFT WING INBD GND SPOILER ATTACH POINT TO OUTBOARD ACTUATOR BROKEN. R & R GND SPOILER IAW MM.SDR SWAA2014122235198Slide · unsecureL1 DOOR SLIDE FALLING OUT OF CONTAINER. SECURED SLIDE IAW MM.SDR SWAA2014121935148Slide · looseL1 DOOR SLIDE FALLING OUT OF CONTAINER. REPOSITIONED SLIDE IAW MM.SDR SWAA2014102933453Stringer · corrodedSTRINGER CORRODED BETWEEN BS 1006 TO 1016, STRINGER 26R. R & R STRINGER IAW DWG & SRM.SDR SWAA2014102933452Stiffener · corrodedU STIFFENER CORRODED BETWEEN BS 1016 TO 1016 + 5, RBL 1. REPAIRED U STIFFENER IAW SRM & EA.SDR SWAA2014102933451Stiffener · corrodedU STIFFENER CORRODED BETWEEN BS 1016 TO 1016 + 6, LBL 1. REPAIRED U STIFFENER IAW SRM & EA.SDR SWAA2014102233234Stiffener · crackedAFT PRESS BULKHEAD CTR DOME PAN Z STIFFENER CRACKED AT BS 1016 STRINGER 3L. REPAIRED Z STIFFENER IAW EA.SDR SWAA2014102933441Bulkhead · corrodedAFT PRESS BULKHEAD WEB SKIN CORRODED AT BS 1016, BETWEEN LBL 0 TO LBL 3. REPAIRED WEB IAW SRM & EA.SDR SWAA2014102933440Bulkhead · corrodedAFT PRESS BULKHEAD CORRODED AT BS 1016, BETWEEN LBL 0 TO LBL 5. REPAIRED BULKHEAD IAW SRM & EA.SDR SWAA2014102233300Door Frame · crackedFORWARD ENTRY DOOR FRAME INNER CHORD CRACKED AT BS 348.2. R & R CHORD IAW EA.SDR SWAA2014092932348Light · inoperativeLEFT FLUORESCENT LIGHTS BETWEEN ROWS 4 TO ROWS 7 WENT OUT & PRODUCED A STRONG ACRID SMELL & LIGHT SMOKE. R & R LIGHT IAW MM.SDR SWAA2014072230209Fan · faultyELECTRICAL SMELL COMING FROM FWD & AFT GALLEY & SPREAD THRU CABIN. R & R RECIRC FAN IAW MM.SDR SWAA2014033126660Light · missingR1 DOOR LOWER EMERGENCY EXIT LIGHT COVER MISSING. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2013120523027Bracket · crackedLT PYLON PANEL 5757L CUTOUT AFT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2013110521974Gasper Fan · faultyBURNING SMELL IN THE CABIN WHILE DESCENDING. FOUND GASPER FAN EMITTING ELECTRIC SMELL & NOISE. R & R GASPER FAN IAW MM.SDR SWAA2013101821283Flap Track · corrodedNR 7 TE FLAP TRACK CORRODED AT WING SPAR ATTACH FITTINGS. R & R NR 7 TE FLAP TRACK IAW MM.SDR SWAA2013101821282Flap Track · corrodedNR 2 TE FLAP TRACK CORRODED AT WING SPAR ATTACH FITTINGS. R & R NR 2 TE FLAP TRACK IAW MM.SDR SWAA2013090519882Battery Pack · dischargedFWD OTBD CABIN FLASHLIGHT INOPERATIVE. R&R BATTERY PACK IAW MM.SDR SWAA2013062417486Flap · out of adjustRT WING INBOARD AFT FLAP OUT OF ADJUSTMENT. ADJUSTED AFT FLAP IAW MM.SDR SWAA2013032614138Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 360, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032614137Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 351, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013040114272Structure · wornRIGHT WING NR 6 SLAT I/B SLAT CAN WORN. REMOVED AND REPLACED SLAT I/B CAN IAW EA.SDR SWAA2013032614136Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 767, STR 27L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013032614135Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032614134Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 767, STR 27R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013032614133Fitting · corrodedKEEL BEAM CLIP CORRODED AT BS 767, STR 27R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032113990Angle · crackedL1 DOOR LOWER WEB SUPPORT ANGLE CRACKED BETWEEN BS 348.2 TO BS 351, STR 16L. REMOVED AND REPLACED ANGLE IAW DWG AND SRM.SDR SWAA2013032113989Support Angle · crackedL1 DOOR UPPER WEB SUPPORT ANGLE CRACKED BETWEEN BS 348.2 TO BS 351, STR 16L. REMOVED AND REPLACED ANGLE IAW DWG AND SRM.SDR SWAA2013032113988Web · crackedL1 DOOR WEB CRACKED AT BS 348.2, STR 16L. REMOVED AND REPLACED WEB IAW DWG AND SRM.SDR SWAA2013032013855Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2013040114259Strap · crackedAFT PIT DOOR CLOSURE SIDEWALL PANEL AFT STRAP CRACKED. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013040114258Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STR 23R TO STR 23L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013040114257Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767 BETWEEN, STR 27R. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2013032614176Stringer Splice · corrodedSTRINGER SPLICE CORRODED BETWEEN BS 360 TO BS 380, STR 28L. REMOVED AND REPLACED SPLICE IAW SRM & DWG.SDR SWAA2013032614132Frame · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STR 27L AND STR 26R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032614152Frame · corrodedSHEAR TIE CORRODED BS 767, BETWEEN STR 26L AND STR 27L LBL 10. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032113993Stiffener · crackedRIGHT MAIN W/W VERTICAL STIFFENER CRACKED AT BS 663.75, RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2013031913843Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013032514036Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500A, LBL 24. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2013032113978Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500A, BETWEEN STR 28R AND STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2013031813745Stiffener · corrodedRIGHT VERTICAL STIFFENER CORRODED AT BS 500D, STR 28R. REMOVED AND REPLACED STIFFENER IAW SRM.SDR SWAA2013030113218Battery · dischargedEMERGENCY FLASHLIGHT RED LIGHT NOT FLASHING. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA2013012111625Structure · damagedNR 6 SLAT INBD SLAT CAN DAMAGED DUE TO CONTACT WITH SLAT TRACK/STOP. R & R NR 6 SLAT CAN IAW SRM AND DWG.SDR SWAA2013012111624Structure · damagedTRANSFERRED FROM NRC C797469 " NR 1 SLAT INBOARD SLAT CAN DAMAGED FROM CONTACT WITH SLAT TRACK/STOP". REMOVED & REPLACED NR 1 SLAT I/B CAN AND PERFORMED SATISFACTORY FUEL LEAK CHECK IAW SRM 51-40-02-01-0G-0 AND BAC DWG 65-45320 AND MM 28-11-00-658-148.SDR SWAA2012122110820Light · inoperativeLEFT ESCAPE SLIDE LIGHT IN INOP. RELAMPED LEFT DOOR ESCAPE SLIDE LIGHT (FWD), PER B737-3 AMM
Back to N613SW, cancelled Jan 2, 2019