N522SW, cancelled Jan 6, 2020
Service difficulty reports · 351
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 = 'N522SW' AND deregistration_id = 'N522SW-2020-01-06' 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 = 'N522SW' AND deregistration_id = 'N522SW-2020-01-06' 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 SWAA102428Pressure Panel · crackedDURING SCHEDULED 18Y CHECK, FOUND WHEEL WELL PRESSURE DECK WEB CRACKED AT BS 664, RBL 41. REPAIRED WEB PER SRM.SDR SWAA102364Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 460, BETWEEN STR 27L TO STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA102363Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED BETWEEN BS 784.25 TO BS 785.5, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA102161Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ER.SDR SWAA102082Tab · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING AILERON TAB I/B END DELAMINATED. REPAIRED TAB PER MM.SDR SWAA102081Tab · delaminatedDURING SCHEDULED 18Y CHECK, FOUND RT WING AILERON TAB O/B END DELAMINATED. REPAIRED TAB PER MM.SDR SWAA102034Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482B, STR 1. REPAIRED FRAME PER SRM.SDR SWAA101197Flap · delaminatedDURING SCHEDULED OTS CHECK, FOUND RT WING O/B FORE FLAP T/E DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA097481Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA094629Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 792, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA094628Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING O/B TRAILING EDGE FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA094627Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 795, STR 8R. REPAIRED SKIN PER SRM.SDR SWAA094626Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 863, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA094625Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 794, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA094624Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA093897Outflow Valve · faultyDIVERSON / DECLARED EMERGENCY. DURING CRUISE AT FL 230, CABIN ALTITUDE WARNING HORN SOUNDED, CREW DONNED 02 MASKS AND COMMENCED DESCENT, COMPLETED QRH CHECKLIST. NO OTHER PROBLEMS NOTED WITH AIRCRAFT (RAPID DEPRESSURIZATION). REMOVED AND REPLACED CABIN PRESDR SWAA093548Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 292 TO BS 304, BETWEEN WL 234 TO WL 262. REPAIRED SKIN PER EA.SDR SWAA093452Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 292 TO BS 304, BETWEEN WL 234 TO WL 262. REPAIRED SKIN PER AAR EA.SDR SWAA093369Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, AT BS 292, WL 232. REPAIRED SKIN PER SRM.SDR SWAA093368Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, AT BS 293, WL 236. REPAIRED SKIN PER SRM.SDR SWAA093367Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, AT BS 292, BETWEEN WL 232 TO WL 236. REPAIRED SKIN PER SRM.SDR SWAA093234Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 400. R&R FRAME PER ACO.SDR SWAA093202Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BEARSTRAP SKIN CRACKED AT L1 DOOR LOWER HINGE, BETWEEN BS 302 TO BS 304, WL 238. REPAIRED SKIN PER AAR EA.SDR SWAA092548Outflow Valve · inoperativeDIVERSION, CABIN PRESSURE CONTROLLER INOP. REMOVED AND REPLACED OUTFLOW VALVE PER MM.SDR SWAA092514Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 954, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA091709Window · arcedON APPROACH OBSERVED L1 WINDSHIELD SPARKING. WINDOW HEAT WORKED NORMAL. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA087027Light · looseFOUND RT FWD EMERGENCY EXIT BULL NOSE LIGHT LOOSE. SECURED LIGHT PER MM.SDR SWAA086972Light · looseRT FWD EMERGENCY EXIT BULLNOSE LIGHT LOOSE. SECURED LIGHT PER MM.SDR SWAA085882Wire · damagedON DEPARTURE COWL ANTI ICE VALVE LIGHT ILLUMINATED AND ENG TO COWL C/B POPPED, ACCOMPANIED WITH ACRID SMELL. WHILE ATTEMPTING TO CLOSE VALVE ACRID SMELL RETURNED AND ENG TO WING CONTROL C/B POPPED. NO MORE RESETS WERE ATTEMPTED. FOUND WIRING DAMAGED AT DISCSDR SWAA083635Drag Brace · vibrationDURING CLIMB WHEN RAISING NLG EXCESSIVE VIBRATION FELT. REMOVED AND REPLACED LOWER DRAG BRACE PER MM.SDR SWAA082258Sign · inoperativeDURING SCHEDULED 16Y CHECK, FOUND FWD CABIN EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA082183Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING EXHAUST DUCT. REPAIRED SKIN PER BOEING SB AND EA.SDR SWAA082199Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 986, RBL 43. REPAIRED FRAME PER SRM.SDR SWAA082198Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CORRODED BETWEEN BS 1016 AND BS 1040, BL 0 AND RBL 38. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082197Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CORRODED BETWEEN BS 1006 AND BS 1016, LBL 38 AND LBL 39. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082184Light · brokenDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA082109Stringer Clip · crackedDURING SCHEDULE 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082085Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 885, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA082051Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 885, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA082052Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947, STR 18R. REPAIRED FRAME PER SRM.SDR SWAA082050Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082038Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 277, BETWEEN STR 14R AND STR 16R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082004Stiffener · crackedDURING SCHEDULED 16Y CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 277, LBL 12, WL 208. REPAIRED STIFFENER PER SRM.SDR SWAA081950Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LEFT BS 616 INBOARD LOWER END. REPAIRED FRAME PER SRM.SDR SWAA081949Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT RIGHT BS 616 INBOARD LOWER END. REPAIRED FRAME PER SRM.SDR SWAA081951Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 16L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA081952Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081915Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081916Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081855Lens · crackedDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.
Back to N522SW, cancelled Jan 6, 2020