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 SWAA2012122110819Fuse · blownOVERHEAD LEFT EXIT SIGN AT L1 DOOR IS INOP. REMOVED & REPLACED M1674 BATTERY POWER FUSE SUPPLY AMM.SDR SWAA2012122610858Stringer · crackedSTA 380 STR 5L HAS EXISTING CRACK IN STRINGER RADIUS. REPAIRED STRINGER PER EA.SDR SWAA2012121210554Stringer Clip · brokenSTR CLIP AT BS 727C STR 1 BROKEN. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012120710325Stand Off · crackedSTA 272 BETWEEN STR 2L AND 3L HAS A CRACKED WIRING STANDOFF ON INTERCOSTAL. REMOVED DAMAGED STANDOFF; INSTALLED REPLACEMENT IAW B737-300 SRM 51-40-02 AT STA 272 S-2L AND S-3L.SDR SWAA2012120710324Stand Off · crackedSTA 277 AT STR 2R LOCATION HAS A CRACKED WIRING STANDOFF ON AFT SIDE OF FRAME. REMOVED DAMAGED STANDOFF; INSTALLED REPLACEMENT IAW B737-300 SRM 51-40-02 AT STA 277 S-2R.SDR SWAA2012121210553Stringer Clip · crackedSTRINGER CLIP IS CRACKED AT STA 344 STR 3L. REMOVED AND REPLACED STRINGER CLIP AT STA 344 STR 3L IAW DWG 65-45815 AND 69-35352, B737-300 SRM 51-40-02. ALODINED & PRIMER IAW B737 SRM 51-20-01.SDR SWAA201212210794Stringer · crackedSTRINGER CRACKED AT BS 500D, STRINGER 2L. REPAIRED STRINGER IAW SRM 53-00-03-2R-3 AND REO G15726 REV IR AND EA 1-353-21198.SDR SWAA2012121210552Fitting · crackedLEFT FUSE STA 927 DOOR SURROUND SEAL FITTING HAS INCOMING CRACK AT TOP EDGE. LOCATED, DRILLED, DEBURRED AND INSTALLED NEW DOOR SURROUND SEAL FITTING IAW B737 SRM 51-40-02 AND BOEING DWG 65-52874 REV L FAY SEALED FITTING IAW BAC 5000.SDR SWAA2012120710323Stringer Splice · crackedRIGHT BS 908 S4R STRINGER SPLICE FITTING HAS INCOMING CRACKS AROUND FASTENER HOLES. REMOVED & INSTALLED NEW STRINGER SPLICE P/N 65-51698U47 PO 761729.1 IAW BAC DWG 65-51698 & B737 SRM 51-40-02.SDR SWAA2012121810772Skin · crackedRIGHT BS 887+10 UPPER WINDOW CORNER HAS HFEC NOISE AT HOLES 4, 5 AND HFEC CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW EA.SDR SWAA2012121810771Skin · crackedRIGHT BS 867+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 4. REPAIRED RIGHT BS 867+10 UPPER AFT WINDOW CORNER IAW EA 1-353-21225 REV- AND REO-15691 REV IR.SDR SWAA2012121810770Skin · crackedRIGHT BS 867+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 9,10. REPAIRED RIGHT BS 867 +10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-21215 REV - , REO G15697 REV IR. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012121810769Skin · crackedRIGHT BS 727A+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE NR 6. REPAIRED RIGHT BS 727A+10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-21244 REV -, REO-G15695 REV IR.SDR SWAA2012121310621Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 9, 10. REPAIRED RIGHT BS 847+10 UPPER AFT WINDOW CORNER IAW SB737-53-1306 REV 2, SECTION 3.B.3 AS PER TASK CARD 10074 STEP 8 FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012121310620Skin · crackedRIGHT BS 847+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 10. REPAIRED RIGHT BS 847+10 LOWER FORWARD WINDOW CORNER IAW SB737-53-1306 R2 SECT 3.B.3 AS PER TASK CARD 10074 STEP 8 FACT AS A RESULT OF POST REPAIR INSPECTIONSDR SWAA2012121110491Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 4. REPAIRED LEFT BS 827 +10 UPPER AFT WINDOW CORNER IAW BOEING SB 737-53-1306, REV 2 SECT 3.B.3. PER TASK CARD 10075. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012121110490Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 5. REPAIRED LEFT BS 807 +10 UPPER AFT WINDOW CORNER IAW BOEING SB 737-53-1306, REV 2 SECT 3.B.3 PER TASK CARD 10075. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012121110489Skin · crackedLEFT BS 807+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 5. REPAIRED LEFT BS 807 +10 LOWER FORWARD WINDOW CORNER IAW BOEING SB 737-53-1306, REV 2, SECT 3.B.3. PER TASK CARD 10075.SDR SWAA2012121010438Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3. REPAIRED RIGHT BS 807 +10 UPPER AFT WINDOW CORNER IAW SB 737-53-1306, REV 2, SECT 3.B.3.SDR SWAA2012121010437Skin · crackedRIGHT BS 767+10 UPPER WINDOW CORNER HAS HFEC NOISE AT HOLE 7 AND CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2012121010436Skin · crackedRIGHT BS 887+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 8. REPAIRED RIGHT BS 887 +10 LOWER FORWARD WINDOW CORNER IAW BOEING SB 737-53-1306, REV 2, SEC 3.B.3 AS PER TASK CARD 10074, STEP 8.SDR SWAA2012121010435Skin · crackedRIGHT BS 807+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 9. REPAIRED RIGHT BS 807 +10 LOWER FORWARD WINDOW CORNER IAW SB 737-53-1306, REV 2, SECT 3.B.3.SDR SWAA2012121010434Skin · crackedRIGHT BS 767+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3. REPAIRED RIGHT BS 767 +10 LOWER FORWARD WINDOW CORNER IAW SB 737-53-1306, REV 2, SECTION 3.B.3. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012121010433Skin · crackedRIGHT BS 727+10 LOWER FORWARD WINDOW CORNER HAS HFEC NOISE INDICATION AT HOLE NR 7. REPAIRED RIGHT BS 727 +10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-21203 REV - , REO G15692, REV IR.SDR SWAA2012121010432Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 3. REPAIRED LEFT BS 887 +10 UPPER AFT WINDOW CORNER IAW EA 1-353-21208 REV - , REO G15699 REV IR. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012121010431Skin · crackedLEFT BS 787+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 3, 9. REPAIRED LEFT BS 787 +10 UPPER AFT WINDOW CORNER IAW SB 727-53-1306, REV 2, SECT 3.B.3.SDR SWAA2012121010430Skin · crackedLEFT BS 827+10 LOWER WINDOW CORNER HAS HFEC CRACKED AT HOLES 1, 2, 3, 5. REPAIRED SKIN IAW BOEING.SDR SWAA2012121010429Skin · crackedLEFT BS 727+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE NR 7. REPAIRED LEFT BS 727 +10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-21209 REV - , REO G15700, REV IR.SDR SWAA2012120710322Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 3. REPAIRED LEFT BS 767+10 UPPER AFT WINDOW CORNER IAW SB737-53-1306 REV 2 SECT 3.B.3 FACT AS A RESULT OF POST REPAIR INSPECTIONSDR SWAA2012120710321Skin · crackedLEFT BS 787+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3. REPAIRED LEFT BS 787+10 LOWER FORWARD WINDOW CORNER IAW SB737-53-1306 REV 2 SECT 3.B.3.SDR SWAA2012120710320Skin · crackedLEFT BS 767+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3. REPAIRED LEFT BS 767 +10 LOWER FORWARD WINDOW CORNER IAW SB 737-53-1306, REV 2, SECT 3.B.3.SDR SWAA2012120610291Skin · crackedRIGHT BS 827+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 8, 9, 10. REPAIRED RIGHT BS 827 +10 LOWER FORWARD WINDOW CORNER IAW SB 737-53-1306, REV 2, SECT 3.B.3. FACT AS A RESULT OF POST REPAIR INSPECTIONSDR SWAA2012120610290Skin · crackedLEFT BS 867+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 3. REPAIRED LEFT BS 867+10 UPPER AFT WINDOW CORNER IAW SB737-53-1306 REV 2 SECT 3.B.3.SDR SWAA2012120610289Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 9, 10, 11. REPAIRED LEFT BS 847+10 UPPER AFT WINDOW CORNER IAW SB 737-53-1306 REV 2 SECT 3.B.3 FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012120610288Skin · crackedLEFT BS 867+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3. REPAIRED LEFT BS 867+10 LOWER FORWARD WINDOW CORNER IAW SB 737-53-1306 REV 2 SECT 3.B.3.SDR SWAA2012081706767Battery Pack · dischargedFORWARD BULKHEAD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER M/M.SDR SWAA2012072406143Flap · puncturedRIGHT INBOARD FORE FLAP PUNCTURED. REMOVED AND REPLACED FORE FLAP PER M/M.SDR SWAA2012061504989Lens · missingCENTER CEILING EMERGENCY EXIT LIGHT LOWER LEFT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA2012051704099Skin · crackedSKIN CRACKED AT BS 757, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012051704098Skin · crackedSKIN CRACKED AT BS 799, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012051704097Skin · crackedSKIN CRACKED AT BS 727D, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012051704096Skin · crackedSKIN CRACKED BETWEEN BS 727C+10 TO BS 727+15, STR 4R. REPAIRED SKIN PER ER AND EA.SDR SWAA2012051704095Skin · crackedSKIN CRACKED BETWEEN BS 776 TO BS 777, STR 4R. REPAIRED SKIN PER ER AND EA.SDR SWAA2013042515203Skin · crackedLEFT WING NR 1 SLAT CRACKED ON LOWER SKIN I/B END AT AFT ROW OF FASTENERS. REPAIRED NR 1 SLAT PER EA AND SRM.SDR SWAA2013032814237Skin · crackedRIGHT WING NR 5 SLAT CRACKED ON LOWER SKIN AT AFT ROW OF FASTENERS. REMOVED AND REPLACED NR 5 SLAT IAW AMM.SDR SWAA2013032814236Skin · crackedLEFT WING NR 2 SLAT CRACKED ON LOWER SKIN AT AFT ROW OF FASTENERS. REMOVED AND REPLACED NR 2 SLAT IAW AMM.SDR SWAA2012021001339Gasper Fan · faultyIMMEDIATELY AFTER SECURING GASPER FAN ON CLIMBOUT FLIGHT ATTENDANTS REPORTED STRONG ELECTRICAL WIRING BURNT SMELL. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA117078Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY. REINSTALLED SLIDE PER MT.SDR SWAA116644Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA115959Fastener · missingDURING SCHEDULED 2HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE BRACKET FASTENER MISSING. INSTALLED FASTENER PER SRM.
Back to N613SW, cancelled Jan 2, 2019