N605SW, cancelled Jul 27, 2018
Service difficulty reports · 423
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 = 'N605SW' AND deregistration_id = 'N605SW-2018-07-27' 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 = 'N605SW' AND deregistration_id = 'N605SW-2018-07-27' 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 SWAA2013022713147Stringer Clip · crackedSTRINGER CLIP AT STA 927, STR 2R IS CRACKED. REMOVED AND REPLACED CLIP IAW BAC DWG & SRM.SDR SWAA2013022613112Stringer Clip · crackedMAIN CABIN STRINGER CLIP STA 400 S-7R FOUND CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2013022613111Stringer Clip · crackedMAIN CABIN STRINGER CLIP STA 480 AT S-8L FOUND CRACKED. REMOVED AND REPLACED CLIP IAW SRM BAC DWG.SDR SWAA2013022613110Stringer Clip · crackedMAIN CABIN STRINGER CLIP STA 380 S-8L FOUND CRACKED. REMOVED AND REPLACED CLIP IAW SRM AND BAC DWG.SDR SWAA2013022513071Stringer Clip · damagedMAIN CABIN STRINGER CLIP STA 500 S3R DAMAGED. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013022513070Stringer Clip · damagedMAIN CABIN STRINGER CLIP STA 440 S2R DAMAGED. REMOVED AND REPLACED CLIP AT IAW SRM.SDR SWAA2013022513069Stringer Clip · damagedMAIN CABIN STRINGER CLIP STA 500 AT STRINGER S3L DAMAGED. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013022513072Stringer Clip · damagedMAIN CABIN STRINGER CLIP STA 500D S3R DAMAGED. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013022513068Stringer Clip · damagedMAIN CABIN STRINGER CLIP STA 500B S-3R DAMAGED. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013022513047Stringer Clip · damagedMAIN CABIN STRINGER CLIP AT STA 360 AT STRINGER S1 DAMAGED. REMOVED AND REPLACED CLIP IAW SRM & DWG.SDR SWAA2013022513046Stringer Clip · damagedMAIN CABIN - DAMAGED STRINGER CLIP AT BS 727E S3L. REMOVED & REPLACED CLIP IAW SRM & BAC DWG.SDR SWAA2013022212990Stringer Clip · damagedMAIN CABIN -- DAMAGED STRINGER CLIP AT BS 867 STRINGER 1. REMOVED AND REPLACED STR CLIP IAW B737 -300 SRM 51-40-02 & BAC DWG 65C46555 REV G.SDR SWAA2013022212989Stringer Clip · damagedMAIN CABIN -- DAMAGED STRINGER CLIP AT BS 827 STRINGER 1. REMOVED & REPLACED STR CLIP IAW B737 -300 SRM 51-40-02 & BAC DWG 65C46552 REV H.SDR SWAA2013022212988Stringer Clip · damagedMAIN CABIN -- DAMAGED STRINGER CLIP AT BS 727E S2R. REMOVED AND REPLACED STR CLIP IAW B737 -300 SRM 51-40-02 & BAC DWG 65C25230 REV J.SDR SWAA2013030413307Skin · crackedRIGHT BS 520+10 UPPER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED SKIN IAW EA.SDR SWAA2013030113217Skin · crackedRIGHT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 4, 6, 7. REPAIRED SKIN CUTOUT IAW EA.SDR SWAA2013022613109Skin · crackedLEFT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CORNER HAS HFEC CRACK INDICATION AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013022513059Skin · crackedRIGHT BS 500C+10 UPPER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 3, 6. REPAIRED SKIN IAW SB.SDR SWAA2013022513058Skin · crackedLEFT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 3. REPAIRED SKIN CUTOUT IAW SB.SDR SWAA2013022513057Skin · crackedLEFT BS 420+10 LOWER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 6, 7. REPAIRED SKIN CUTOUT IAW EA.SDR SWAA2013022513056Skin · crackedLEFT BS 500C+10 UPPER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 3. REPAIRED SKIN CUTOUT IAW SB.SDR SWAA2013022513074Skin · crackedLEFT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 3, 5. REPAIRED SKIN CUTOUT IAW EA.SDR SWAA2013022012920Skin · crackedRIGHT BS 400+10 LOWER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE NR 2. REPAIRED RIGHT BS 400 +10 LOWER AFT WINDOW CORNER IAW BOEING SB 737-53-1306 REV 2, SECTION 3B3. PER TASK CARD 10073, STEP 8.SDR SWAA2013022012919Skin · crackedRIGHT BS 380+10 LOWER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED RIGHT BS 380+10 LOWER AFT WINDOW CORNER IAW BOEING SB 737-53-1306 REV 2, SECTION 3B3, PER TASK CARD 10073, STEP 8. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013022012918Skin · crackedRIGHT BS 500+10 UPPER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 3, 9. REPAIRED RIGHT 500+40 UPPER FORWARD WINDOW CORNER IAW BOEING SB 737-53-1306 REV 2, SECTION 3 B3 PER TASK CARD 10073, STEP 8. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013022012917Skin · crackedLEFT BS 460+10 LOWER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 5, 6, 7. REPAIRED LEFT BS 480+10 LOWER AFT WINDOW CORNER IAW BOEING SB 737-53-1306 REV 2 SECT 3BB PER TASK CARD 10072. STEP 8. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013022012916Skin · crackedLEFT BS 440+10 LOWER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED LEFT BS 440+10 LOWER AFT WINDOW CORNER IAW BOEING SB 737-53-1306 REV 2 SECT 3 B3 PER TASK CARD 10072 REV 3 STEP 8.SDR SWAA2013022012915Skin · crackedLEFT BS 380+10 UPPER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 3. REPAIRED LEFT BS 380+10 UPPER FORWARD WINDOW CORNER IAW BOEING SB 737-53-1306 REV 2 SECT 3 B3 PER TASK CARD 10072 REV 3 STEP 8.SDR SWAA2013030513341Skin · crackedRIGHT BS 747+10 LOWER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE 8. REPAIRED SKIN IAW EA.SDR SWAA2013030413306Skin · crackedLEFT BS 727+10 UPPER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 6. REPAIRED SKIN IAW EA.SDR SWAA2013030413305Skin · crackedLEFT BS 727+10 LOWER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE 7. REPAIRED SKIN IAW EA.SDR SWAA2013030413304Skin · crackedRIGHT BS 807+10 LOWER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 5. REPAIRED SKIN IAW EA.SDR SWAA2013030113216Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLES 2, 3, 5, 6. REPAIRED SKIN CUTOUT IAW EA.SDR SWAA2013022813178Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED INDICATION AT HOLES 3, 7. REPAIRED SKIN IAW EA.SDR SWAA2013022813177Skin · crackedLEFT BS 727E+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED INDICATION AT HOLE NR 2. REPAIRED SKIN IAW EA.SDR SWAA2013022613108Skin · crackedRIGHT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 5, 6. REPAIRED SKIN IAW EA.SDR SWAA2013022613107Skin · crackedRIGHT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CORNER HAS HFEC CRACK INDICATION AT HOLES 3, 5. REPAIRED SKIN IAW EA.SDR SWAA2013022613106Skin · crackedRIGHT BS 727+10 LOWER FORWARD WINDOW SKIN CUTOUT CORNER HAS HFEC CRACK INDICATION AT HOLE NR 7. REPAIRED SKIN IAW EA.SDR SWAA2013022513055Skin · crackedLEFT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE NR 3. REPAIRED SKIN CUTOUT IAW SB.SDR SWAA2013022513054Skin · crackedLEFT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE NR 3. REPAIRED SKIN CUTOUT IAW SB.SDR SWAA0255020113053Skin · crackedRIGHT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE NR 3. REPAIRED SKIN CUTOUT IAW BOEING SB.SDR SWAA2013022112956Skin · 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 BOEING SB 737-53-1306.SDR SWAA2013022112955Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3. REPAIRED RIGHT BS 827 +10 UPPER AFT WINDOW CORNER IAW BOEING SB.SDR SWAA2013022012914Skin · crackedLEFT BS 867+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED LEFT BS 867 +10 UPPER AFT WINDOW CORNER IAW SB 737-53-1306 REV 2 AND TASK CARD 10075 STEP 8.SDR SWAA2013022012913Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED LEFT BS 827+10 UPPER AFT WINDOW CORNER IAW SB 737-53-1306 REV 2 SECT 3 B3 AND TASK CARD 10075 FIGURE 9. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013022012912Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED LEFT BS 807+10 UPPER AFT WINDOW CORNER IAW SB 737-53-1306 REV 2 SECT 3 B3 AND TASK CARD 10075 FIGURE 9. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013022012911Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED LEFT BS 767+10 UPPER AFT WINDOW CORNER IAW SB 737-53-1306 REV 2 SECT 3 B3 AND TASK CARD 10075 FIGURE 9.SDR SWAA2013022012910Skin · crackedLEFT BS 827+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3. REPAIRED LEFT BS 827+10 LOWER FORWARD WINDOW CORNER IAW SB 737-53-1306 REV 2 SECT 3.B3. AND TASK CARD 10075 FIGURE 9. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013022012909Skin · crackedLEFT BS 787+10 UPPER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE 3. REPAIRED LEFT BS 787+10 LOWER FORWARD WINDOW CORNER IAW SB737-53-1306 REV 2 SECT 3.B.3 AND TASK CARD 10075 FIGURE 9. FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013040914592Panel · crackedUPPER RIGHT WING TRAILING EDGE PANEL 5835R CRACKED IN RADIUS. REPAIRED PANEL IAW SRM.
Back to N605SW, cancelled Jul 27, 2018