N676SW, cancelled Oct 26, 2017
Service difficulty reports · 282
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 = 'N676SW' AND deregistration_id = 'N676SW-2017-10-26' 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 = 'N676SW' AND deregistration_id = 'N676SW-2017-10-26' 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 SWAA020400Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA012283Tab · wornDURING SCHEDULED C4 CHECK, FOUND PLAY AT RH ELEVATOR TAB ATTACH ASSY. R&R ELEVATOR TAB PER MM.SDR SWAA012119Cover · missingEEPLS COVER MISSING AT OVERWING EXIT. INSTALLED COVER PER MM.SDR SWAA011789Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CORRODED AT BS 515, STR 27R. REPAIRED STR PER SRM.SDR SWAA011788Stiffener · crackedDURING SCHEDULED 1/4D CHECK, FOUND MLG WHEEL WELL BULKHEAD VERTICAL STIFFENER CRACKED BS 663, LBL6.15. R&R STIFFENER PER SRM.SDR SWAA011743Stiffener · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL STIFFENER CRACKED IN MAIN WHEEL WELL BULKHEAD BS 663, RBL 615. REPAIRED STIFFENER PER SWA RA.SDR SWAA011711Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA011703Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CORRODED, AT BS 500D, STR 26R. REPAIRED STR PER SRM.SDR SWAA011682Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AFT CARGO BS 787, STR 27R. REPAIRED FLOORBEAM PER SRM.SDR SWAA011683Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAMS AFT CARGO AT BS 860, LBL 8, RBL 3 & RBL 8. REPAIRED FLOORBEAMS PER SWA RA.SDR SWAA011663Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED IN AFT CARGO AT BS 807 & BS 860, LBL 17. REPAIRED FLOORBEAMS PER SRM.SDR SWAA011650Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STR CLIP CRACKED AT BS 500C, STR 27L. Removed and replaced STR CLIP PER SRM.SDR SWAA011662Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA011643Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SVC DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA011579Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT & RT WALKING BEAM HANGER FITTINGS CORRODED AT FWD OTBD, LT & RT MLG. REMOVED AND REPLACED BOTH WALKING BEAM HANGER FITTINGS PER MM.SDR SWAA011215Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP. R&R BATTERY CHARGER PER MM.SDR SWAA011065Battery Pack · dischargedDURING SCHEDULED C3 CHECK, FOUND EEPLS INOP AT AFT SECTION. R&R BATTERY PACK PER MM.SDR SWAA011066Slat · delaminatedDURING SCHEDULED C3 CHECK, FOUND NR 5 L/E SLAT DELAMINATED AT OUTBD UPPER T/E SURFACE. R&R NR 5 SLAT PER MM.SDR SWAA011064Cap · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS END CAP MISSING AT FWD SECTION. INSTALLED END CAP PER MM.SDR SWAA011063Slide · unserviceableDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EVAC SLIDE ASSY PER MM.SDR SWAA010983Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHTS DIM AT AFT CABIN. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA010678Ballast · inoperativeELECTRIC BURNING ODOR AT ROWS 17 TO 18, RIGHT SIDE. FOUND WINDOW LIGHT BALLAST INOP. REMOVED AND REPLACED BALLAST PER MM.SDR SWAA010062Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA002738Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 2 CRACK AT LT HORIZ STAB SKIN, 4 FT OTBD AT AFT SPAR. REPAIRED SKIN PER SRM.SDR SWAA002737Slide · out of adjDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUSTMENT. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA002736Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND EEPLS INOP AT ROW 10, LOOSE AT ROW 1 & WIRING EXPOSED AT ROW 3. REPAIRED EEPLS PER MM.SDR SWAA002373Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD VERTICAL BEAMS CRACKED AT LBL 17.1, WL 229.5 & RBL 10, WL 234. REPAIRED BULKHEAD PER ER 00-1268.SDR SWAA002374Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD VERTICAL WEBS CRACKED AT LBL 17.1, WL 182 & RBL 17.1, WL 182. REPAIRED BULKHEAD PER ER 00-1282 & ER 12-1283.SDR SWAA002302Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD CRACKED AT WL 218, RBL 11 TO RBL 12. REPAIRED BULKHEAD PER SRM.SDR SWAA001356Cover · looseFWD SERVICE DOOR EVACUATION SLIDE SHELL OPENED WHEN DOOR WAS OPENED. RE-INSTALLED SLIDE ASSY PER MM.SDR SWAA000994Girt Bar · out of adjDURING SCHEDULED C4 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000324Light · inoperativeAFT SERVICE DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.
Back to N676SW, cancelled Oct 26, 2017