N657SW, cancelled Mar 15, 2018
Service difficulty reports · 446
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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-15' 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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-15' 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 SWAA2012100108215Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW MT.SDR SWAA2012092507970Support · corrodedUPPER FLANGE LOWER SIDE OF SUPPORT STRUCTURE CORRODED AT BS 338, STR 23L. REMOVED AND REPLACED STRUCTURE IAW DWG.SDR SWAA2012092507957Stringer · corrodedSTRINGER CORRODED AT BS 325, BL 0. REMOVED AND REPLACED STRINGER IAW SRM.SDR SWAA2012092507956Sill · corrodedR1 DOOR LOWER SILL WEB CORRODED BETWEEN BS 294 TO BS 328. REMOVED AND REPLACED WEB IAW DWG.SDR SWAA2012092007809Door Frame · crackedR1 DOOR FWD FRAME CUTOUT CRACKED AT BS 294.5, WL 208. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012092608035Fitting · crackedKEEL BEAM INBOARD CLIP CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED CLIP IAW DWG & SRM.SDR SWAA2012091907746Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2012100408280Skin · crackedR1 DOOR FUSELAGE SKIN CRACKED AT UPPER FORWARD CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100308239Bulkhead · crackedBULKHEAD CHORD CRACKED AT BS 664, BL 0. REPAIRED CHORD IAW EA.SDR SWAA2012100108101Wire · brokenL1 DOOR EMERGENCY EXIT LIGHT WIRE BROKEN. REMOVED AND REPLACED LIGHT IAW AMM.SDR SWAA2012092507955Crease Beam · corrodedR1 DOOR CREASE BEAM CHORD CORRODED. REMOVED AND REPLACED BEAM IAW DWG AND SRM.SDR SWAA2012091907745Web · crackedFORWARD ENTRY DOOR FORWARD CUTOUT WEB CRACKED AT BS 303.9. REPAIRED WEB PER ACO.SDR SWAA2012091907744Girt Bar · corrodedL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR ATTACH POINT CORRODED. REMOVED AND REPLACED GIRT BAR IAW SRM AND DWG.SDR SWAA2012091707671Bracket · corrodedL1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR ATTACH POINT UPPER SURFACE CORRODED. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA2012100108214Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE IAW DWG AND SRM.SDR SWAA2012100108213Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STR 28L TO 28R. REMOVED AND REPLACED SHEAR TIE IAW DWG AND SRM.SDR SWAA2012092007812Floorbeam · corrodedFLOORBEAM T-CAP CORRODED AT BS 967, BETWEEN LBL 33 TO RBL 31. REPAIRED T-CAP IAW SRM.SDR SWAA2012091907777Web · crackedFORWARD GALLEY DOOR WEB CRACKED AT BS 294.5, STR 9R. REMOVED AND REPLACED L-ANGLE IAW SRM AND DWG.SDR SWAA2012091807726Web · crackedWEB CRACKED AT STA 986.5, STR 9R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012091807725Web · crackedFORWARD CARGO COMPARTMENT DOOR AFT CUTOUT ENCLOSURE WEB CRACKED AT BS 490, STR 25R. REMOVED AND REPLACED WEB IAW SRM & DWG.SDR SWAA2012100508304Spoiler · delaminatedRIGHT WING NR 6 SPOILER UNDER SIDE INBOARD OF ACTUATOR ATTACH CUT OUT DELAMINATED. REMOVED AND REPLACED NR 6 SPOILER IAW AMM.SDR SWAA2012091707670Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 727A, STR 20L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012090707431Floorbeam · crackedLONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 665, LBL 24.8. REPAIRED CHORD IAW SRM.SDR SWAA2012100308227Keelbeam · corrodedRIGHT KEEL BEAM CORRODED AT BS 500D+9. REPAIRED BEAM IAW EA.SDR SWAA2012100108212Keelbeam · corrodedLEFT KEEL BEAM CORRODED AT BS 500D+10, LBL 6.5. REPAIRED BEAM IAW SRM & DWG.SDR SWAA2012081506719Skin · crackedLEFT WING NR 3 SLAT LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA2012050903833Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2012050903832Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2012041303090Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE GAUGE PRESSURE LOW. REMOVED AND REPLACED SLIDE ASSY PER MT.SDR SWAA2012021301393Flap · delaminatedRT WING I/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP IAW MM.SDR SWAA117449Skin · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING NR 8 SPOILER DELAMINATED. REMOVED AND REPLACED GROUND SPOILER PER MM.SDR SWAA116507Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR, BS 290.50, WL 235.50 ON LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA116138Floorbeam · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER EA.SDR SWAA111426Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 19R. REPAIRED SKIN PER EA.SDR SWAA107329Skin · delaminatedDURING SCHEDULED 26Y CHECK, FOUND LT WING AILERON TAB UPPER SURFACE DELAMINATED. REPAIRED TAB PER SRM.SDR SWAA107328Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOOR BEAM CHORD CRACKED AT BS 344, BETWEEN LBL 47 TO LBL 49. REPAIRED CHORD PER EA.SDR SWAA107327Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, LBL 50. REPAIRED BEAM PER EA.SDR SWAA107326Floor Support · corrodedDURING SCHEDULED 26Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 793, LBL 8. REPAIRED SUPPORT PER EA.SDR SWAA107079Shear Tie · crackedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, BETWEEN STR 19L TO STR 20L. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA107078Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA107077Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA107042Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA106969Carriage · crackedDURING SCHEDULED 26Y CHECK, FOUND RT WING O/B TRAILING EDGE FLAP CARRIAGE SPINDLE CRACKED. REMOVED AND REPLACED NR 8 FLAP CARRIAGE PER MM.SDR SWAA106870Floor Support · corrodedDURING SCHEDULED 26Y CHECK, FOUND FLOOR SUPPORT CORRODED BETWEEN BS 904 TO BS 907, LBL 12. REMOVED AND REPLACED SUPPORT PER EA.SDR SWAA106856Floor Support · corrodedDURING SCHEDULED 26Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 772, RBL 8. REPAIRED SUPPORT PER SRM AND EA.SDR SWAA106855Floor Support · corrodedDURING SCHEDULED 26Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 772, RBL 3. REPAIRED SUPPORT PER SRM AND EA.SDR SWAA106854Floor Support · corrodedDURING SCHEDULED 26Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 772, LBL 3. REPAIRED SUPPORT PER SRM AND EA.SDR SWAA106853Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 26L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105450Handle · dirtyON APPROACH GEAR INDICATED 3 GREEN AND 3 RED. CYCLED LT GEAR. FOUND LANDING GEAR HANDLE STICKING OUT WHEN PUT IN "DOWN" DETENT CLEANED HANDLE PER MM.SDR SWAA102711Actuator · faultyAFTER REQUESTING "LANDING GEAR DOWN" HAD NORMAL INDICATIONS FOR NOSE AND LEFT MAIN BUT RED RIGHT GEAR AND NO GREEN LIGHT. RECYCLED LANDING GEAR ALL INDICATIONS NORMAL. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.
Back to N657SW, cancelled Mar 15, 2018