N645SW, cancelled Nov 20, 2017
Service difficulty reports · 286
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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 SWAA2012061204860Stringer · corrodedSTRINGER CORRODED AT BS 747, STR 27R. REPAIRED STRINGER IAW SRM.SDR SWAA2012070205490Skin · crackedSKIN CRACKED AT BS 360+18, LBL 3. REPAIRED SKIN IAW EA.SDR SWAA2012070205489Skin · crackedSKIN CRACKED AT BS 211.8, STR 9L. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012062605318Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STR 27R TO STR 28R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012062605303Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012062505250Frame · corrodedFRAME CORRODED AT BS 500A, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2012062505249Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012062505244Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM DWG.SDR SWAA2012061104804Skin · crackedSKIN CRACKED AT BS 520+7, RBL 5. REPAIRED SKIN IAW EA.SDR SWAA2012070205488Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 660 TO BS 680, LBL 24.5. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012062105136Retainer · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER CLIP LOOSE. REMOVED AND REPLACED CLIP IAW AND DWG.SDR SWAA2012061805007Retaining Clip · looseR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR RETAINER CLIP LOOSE. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2012052104169Actuator · leakingRIGHT WING NR 6 SPOILER ACTUATOR LEAKED. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA2012031202117Charger · inoperativeCENTER AISLE EMERGENCY EXIT LIGHT IS INOP. REMOVED AND REPLACED BATTERY PACK CHARGER ASSY IAW AMM.SDR SWAA2012031202108Charger · inoperativeRIGHT OVERWING UPPER EMERGENCY EXIT LIGHT IS INOP. REMOVED AND REPLACED BATTERY PACK CHARGER ASSY IAW AMM.SDR SWAA2012031202116Stiffener · crackedVERTICAL STIFFENER ANGLE CRACKED AT BS 727, LBL 5. REMOVED & REPLACED STIFFENER IAW BAC DWG.SDR SWAA2012031202115Keelbeam · wornLT KEEL BEAM WORN BETWEEN BS 625 TO BS 727+14. REPAIRED BEAM IAW SRM.SDR SWAA2012022001593Mount · crackedR2 DOOR EMERENCY EVAC SLIDE FWD SLIDE MOUNT CRACKED. REMOVED AND REPLACED MOUNT PER MM.SDR SWAA2012022001592Bracket · looseR2 DOOR EMERGENCY EVAC SLIDE BRACKET LOOSE. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA117835Control Valve · leakingDECLARED EMERGENCY - NR 2 ENGINE HYDRAULIC 'LOW PRESSURE' LIGHT ILLUMINATED IN FLIGHT. FOUND AUTO BRAKE CONTROL VALVE LEAKED. REMOVED AND REPLACED VALVE PER MM.SDR SWAA115624Spoiler · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 8 SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA115623Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 520+10, STR 28L. REPAIRED SKIN PER EA.SDR SWAA115622Slide · out of positionDURING SCHEDULED 2HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA114805Hook · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOOK LOOSE. REMOVED AND REPLACED HOOK ASSY PER MM.SDR SWAA113324Lens · looseDURING SCHEDULED CV CHECK FOUND FWD CABIN EMERGENCY EXIT LIGHT LENS ABOVE FWD LAV DOOR LOOSE. TIGHTENED EMERGENCY LIGHT LENS PER MM.SDR SWAA110146Web · crackedDURING SCHEDULED 14Y CHECK, FOUND FLIGHT DECK FLOOR WEB CRACKED AT FWD I/B MOUNTING HOLE FOR OPC CRADLE. REPAIRED WEB PER ACO.SDR SWAA110145Web · crackedDURING SCHEDULED 14Y CHECK, FOUND FLIGHT DECK FLOOR WEB CRACKED AT FWD O/B MOUNTING HOLE FOR OPC CRADLE. REPAIRED WEB PER ACO.SDR SWAA110061Flap · delaminatedDURING SCHEDULED 14Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA110002Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA108018Floorbeam · corrodedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM ENTIRE UPPER FLANGE CORRODED AT BS 986. REPAIRED BEAM PER EA.SDR SWAA107950Stringer Splice · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER SPLICE 4R CRACKED AT BS 907. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA107799Structure · crackedDURING SCHEDULED 2HC1 CHECK, FOUND L1 DOOR LOWER HINGE BOX CRACKED IN RADIUS. REMOVED AND REPLACED HINGE BOX PER SRM.SDR SWAA107184Casting · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CASTING. REMOVED AND REPLACED CASTING PER MM AND SRM.SDR SWAA105040Slide · looseDURING SCHEDULED CV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA104756Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA104715Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA103287Sign · damagedL1 DOOR EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED SIGN PER MM.SDR SWAA103091Skin · puncturedDURING SCHEDULED HC2 CHECK, FOUND RT WING I/B MID FLAP LOWER SKIN PUNCTURED. REPAIRED FLAP PER SRM.SDR SWAA103090Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING OUTBOARD AFT FLAP DELAMINATED AT I/B END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA103070Pressure Panel · crackedDURING SCHEDULED HC2 CHECK, FOUND LT MLG CEILING PRESSURE WEB CRACKED AT BS 663, LBL 39. REPAIRED WEB PER EA AND SRM.SDR SWAA102404Controller · faultyDIVERSION - DURING FLIGHT, PASSENGERS AND FLIGHT ATTENDANT REPORTED "HEAT SMELL" IN FWD CABIN. SIDEWALL PANEL ROW 8 ON F/O'S SIDE BECAME EXTREMELY WARM. REMOVED AND REPLACED CABIN TEMP CONTROLLER, RT A/C MIX VALVE, AND RT ANTICIPATOR SENSOR, AND T415 SENSOR SDR SWAA102196Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND EMERGENCY BULL NOSE LIGHT INOP BETWEEN ROW 10 TO 17. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA101882Light · missingRT EEPLS MISSING AT ROW 16. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA100988Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 510D, STR 10R. REPAIRED SKIN PER EA.SDR SWAA095514Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 511D, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA092389Light · brokenL1 DOOR FLOOR LEVEL EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA092275Light · looseDURING SCHEDULED 12Y CHECK, FOUND EEPLS STRIP LOOSE BETWEEN ROW 13 TO ROW 15. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA092274Battery Pack · dischargedDURING SCHEDULED 12Y CHECK, FOUND AFT OVERHEAD EMERGENCY EXIT SIGN INOP. INSTALLED BATTERY PACK PER MM.SDR SWAA092273Battery Pack · dischargedDURING SCHEDULED 12Y CHECK, FOUND L2 DOOR EMERGENCY EXIT SIGN INOP. INSTALLED BATTERY PACK PER MM.SDR SWAA092272Battery Pack · dischargedDURING SCHEDULED 12Y CHECK, FOUND R2 DOOR EMERGENCY EXIT SIGN INOP. INSTALLED BATTERY PACK PER MM.
Back to N645SW, cancelled Nov 20, 2017