N659SW, cancelled Mar 28, 2018
Service difficulty reports · 545
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 = 'N659SW' AND deregistration_id = 'N659SW-2018-03-28' 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 = 'N659SW' AND deregistration_id = 'N659SW-2018-03-28' 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 SWAA042652Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT 328, LBL 12, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR SWAA042641Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CHORD AT BS 312, RBL 20 TO LBL 20, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR SWAA042631Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CHORD AT BS 616, LBL 65, WL 200, CRACKED. REMOVED AND REPLACED FRAME CHORD SECTION PER SB.SDR SWAA042624Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 767, STRINGER 8L & STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042623Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 807, STRINGER 8L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042621Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 440, STRINGER 8L & STRINGER 8R CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042625Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP AT BS 727D, STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA042622Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME AT BS 480, STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042620Frame · corrodedDURING SCHEDULED D CHECK, FOUND FRAME AT BS 994, RBL 44, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042605Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP AT BS 685, STRINGER 2L, CRACKED. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA042604Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICES AT BS 907, STRINGER 4R AND STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA042603Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME AT BS 907, STRINGER 8R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA042602Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME AT BS 747, STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042095Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING AFT INBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING INBOARD AFT T/E FLAP PER MM.SDR SWAA042059Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING OUTBOARD AFT FLAP PER MM.SDR SWAA042058Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 25L, BS 747, STRINGER 23R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042057Skin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT RIGHT KEEL BEAM BS 500C TO RT KEELBEAM BS 500D, CORRODED. REPAIRED SKIN PER EA.SDR SWAA042047Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 20L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042014Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 20L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041327Battery · inoperativeDURING SPV, FOUND R2 DOOR EVAC SLIDE LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA041326Battery · inoperativeDURING SPV, FOUND EMERGENCY EXIT LIGHTS RT MID CABIN, INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA041325Bulkhead · corrodedDURING SPV, FOUND BULKHEAD PRESSURE WEB AT BS 1016, RBL 2 TO LBL 2, CORRODED. REPAIRED PRESSURE WEB PER ER.SDR SWAA041007Bracket · brokenDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE FWD ATTACH BRACKET BROKEN. REMOVED AND REPLACED R2 DOOR EVAC SLIDE BRACKET PER MM.SDR SWAA040955Battery · inoperativeDURING SCHEDULED RON, FOUND LT CENTER AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA040771Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040569Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED THE L1 DOOR EVAC SLIDE INTO CONTAINER PER MM.SDR SWAA040498Slide · looseL1 DOOR EVAC SLIDE LOOSE. SECURED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040327Module · faultyAIRTURN BACK, POWER STANDBY LIGHT ILLUMNINATED IN FLIGHT. QRH PROCEDURES FOLLOWED. LIGHT WOULD NOT RESET. REMOVED AND REPLACED STANDBY POWER MODULE PER MM.SDR SWAA040098Slide · out of adjustR2 DOOR EVAC SLIDES OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDES PER MM.SDR SWAA032836Frame · crackedDURING SCHEDULED C4 CHECK, FOUND L1 DOOR LOWER FRAME WEB CRACKED AT FWD STOP FITTING. REMOVED AND REPLACED L1 DOOR ASSY PER MM.SDR SWAA032835Frame · crackedDURING SCHEDULED C4 CHECK, FOUND R2 DOOR UPPER HINGE BOX FRAME ASSY BROKEN. REPAIRED UPPER HINGE BOX FRAME ASSY PER SRM.SDR SWAA032603Control Panel · faultyDIVERSION, CABIN ALTITUDE WARNING HORN SOUNDED, BOTH A/C PACKS SET IN HIGH AND NO HELP, OUTFLOW VALVE INDICATED FULL CLOSED. REMOVED AND REPLACED CABIN PRESS CONTROL PANEL AND RESEALED L1 DOOR HINGE AREAS PER MM.SDR SWAA031596Oil System · contaminatedIN FLIGHT SHUTDOWN, DECLARED EMERGENCY, NR 1 ENGINE OIL PRESS LIGHT ILLUMINATED, OIL QUANITY WAS AT ZERO. FOUND TORLON CHIPS IN LUB UNIT, CLEANED AND REINSTALLED PER MM.SDR SWAA031570Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA031277Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT INBD AFT T/E FLAP DELAMINATED ON LOWER SURFACE. REMOVED AND REPLACED RT INBD AFT T/E FLAP PER MMSDR SWAA031050Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 873 & BS 876, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA030622Engine · failed( IN-FLT SHUTDOWN, DECLARED EMERGENCY )……………………..DURING CLIMB # 1 ENGINE SHUTDOWN, WOULD NOT RESTART. R&R # 1 ENGINE PER MM.SDR SWAA023018Skin · crackedDURING SCHEDULED CHECK, FOUND FUSELAGE SKIN CRACKED (5 EA) BETWEEN BS 727D AND BS 887, BETWEEN STR 22L AND STR 25L. REPAIRED SKIN PER SRM.SDR SWAA022252Lens · crackedDURING SCHEDULED BC3 CHECK, FOUND FWD ENTRY DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA021835Door · crackedDURING SCHEDULED C3 CHECK, FOUND AFT CARGO DOOR CRACKED AT FWD END BETWEEN 2ND AND 3RD STOPS. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA021837Slide · looseDURING SCHEDULED BC3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE NYLON CORD HANGING OUT OF GIRT AREA. STOWED NYLON CORD PER MM.SDR SWAA021836Slide · out of positionDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020672Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND CAPTIAN'S WINDOW POST SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA020671Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 234 AND LBL 11.0. REPAIRED WEB PER SRM.SDR SWAA020632Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED (2 EA) AT BS 178, WL 218, LBL 11.5 AND WL 212.5, RBL 7.0. REPAIRED WEB PER SRM.SDR SWAA020641Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD LOWER CORNER OF AFT CARGO DOOR CUTOUT. REPAIRED SKIN PER SWA RA.SDR SWAA020615Door · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME CRACKED AT AFT DOOR STOP CUTOUT NR 6 FROM TOP. REMOVED AND REPLACED DOOR PER MM.SDR SWAA020603Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 727B, LBL 2 TO LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA020602Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME CRACKED AT AFT DOOR STOP CUTOUT NR 7 FROM TOP. REPAIRED FRAME PER SRM.SDR SWAA020594Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED (2 EA) AT BS 178, WL 234, LBL 12 AND WL 210, RBL 7.0. REPAIRED WEB PER SRM.
Back to N659SW, cancelled Mar 28, 2018