N605SW, cancelled Jul 27, 2018
Service difficulty reports · 423
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 = 'N605SW' AND deregistration_id = 'N605SW-2018-07-27' 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 = 'N605SW' AND deregistration_id = 'N605SW-2018-07-27' 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 SWAA2015012135928Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 320, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2015011935870Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 328, STRINGER 20L. R & R TIE CLIP IAW SRM.SDR SWAA2015011535773Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 660, LBL 24.8. REPAIRED BEAM IAW ER & EA.SDR SWAA2015011435728Strap · crackedFLOORBEAM STABILIZING STRAP CRACKED AT BS 328, BL 10. REPAIRED STRAP IAW SRM.SDR SWAA2015010635498Strap · crackedFLOORBEAM STABILIZING STRAP AT CRACKED AT BS 328, BL 0. REPAIRED STRAP IAW SRMSDR SWAA2015010635497Stringer · crackedSTRINGER CRACKED AT BS 360, STRINGER 2L. R & R STRINGER IAW SRM.SDR SWAA2015012235976Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360, STRINGER 24L. R & R SPLICE IAW SRM & DWG.SDR SWAA2015012235975Keelbeam · corrodedFORWARD CARGO LT KEEL BEAM LOWER CHORD CORRODED AT BS 500D. REPAIRED CHORD IAW EA & ER.SDR SWAA2015012636054Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2015012336014Attach Fitting · crackedLEFT WING RSS 553 WIPER WEB ATTACH CLIP CRACKED. R & R CLIP IAW SRM.SDR SWAA2015012636052Beam · crackedLONGITUDINAL BEAM UPPER CHORD CRACKED AT BS 667, LBL 24.8. REPAIRED CHORD IAW ER & EA.SDR SWAA2015012636051Slide · out of adjustR1 DOOR EMER EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW AMM.SDR SWAA2015012636053Attach Fitting · crackedRIGHT WING RSS 553 WIPER WEB ATTACH CLIP CRACKED. R & R CLIP IAW SRM.SDR SWAA2015012235964Support Angle · crackedRIGHT WING SEAL SUPPORT ANGLE CHORD CRACKED ON OTBD SIDE OF NR 2 PYLON JUST AFT OF UPPER TE PANEL. REPAIRED CHORD IAW ACO & EA.SDR SWAA2015012135927Skin · crackedCAPTAIN'S NR 1 WINDOW C - D POST FUSELAGE SKIN CRACKED AT UPPER END SIDE. REPAIRED SKIN IAW SRM.SDR SWAA2015011435727Skin · crackedFIRST OFFICER'S NR 1 WINDOW C - D WINDOW POST UPPER END SIDE FUSELAGE SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2015010935606Fitting · crackedLONGITUDINAL FLOORBEAM CLIP CRACKED AT BS 639, RBL 45.5. R & R CLIP IAW SRM.SDR SWAA2014123035331Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 709 TO 712, RBL 24.75. REPAIRED BEAM IAW EA.SDR SWAA2015012135943Beam · crackedLONGITUDINAL BEAM UPPER CHORD CRACKED BETWEEN BS 667 TO 671, RBL 24.8 AT FWD LOWER CORNER & UPPER AFT CORNER. REPAIRED CHORD IAW ER & EA.SDR SWAA2015011335709Rib · crackedRIGHT HORIZONTAL STABILIZER REMOVABLE LE 3RD RIB OTBD OF INBD END CRACKED. REPAIRED RIB IAW SRM.SDR SWAA2015012936178Skin · crackedLOWER FUSELAGE SKIN CRACKED AT OPENING FOR GND SERVICE AIR CONDITIONING ACCESS DOOR. REPAIRED CUT OUT IAW SRM.SDR SWAA2015012736126Structure · crackedLEFT OTBD CHORD CRACKED AT BS 727, STRINGER 18A LOWER FWD HOLE CRACKED FWD & AFT SIDE OF HOLE. REPAIRED CHORD IAW EA & SRM.SDR SWAA2015012636086Intercostal · crackedINTERCOSTAL CHANNEL CRACKED AT BS 540, STRINGER 25L. R & R INTERCOSTAL IAW SRM.SDR SWAA2015011335718Skin · brokenRIGHT SIDE GND SERVICE AIR CONDITIONING ACCESS DOOR CUT OUT FUSELAGE SKIN BROKEN. REPAIRED CUT OUT IAW SRM.SDR SWAA2014120134568Retaining Clip · brokenFORWARD ENTRY EMER EXIT LIGHT COVER RETAINING CLIPS BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014081530907Flap · delaminatedLEFT WING INBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014071029841Hydraulic Line · failedB HYD QTY GAUGE SHOWED 1/2 FULL. ON APPROACH ENG 2 LOW PRESS LIGHT FLICKERED TWICE. R & R B SYS ELEC HYD PUMP PRESS LINE IAW MM.SDR SWAA2014032426414Flap · delaminatedLT WING OTBD AFT FLAP DELAMINATED ON INBD END. R & R AFT FLAP IAW MM.SDR SWAA2014030325692Skin · delaminatedRT WING INBD AFT FLAP OTBD EDGE LOWER SURFACE DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014030325691Stringer · corrodedSTRINGER CORRODED AT BS 1016, STRINGER 25L. R & R STRINGER IAW DRAWING.SDR SWAA2014031726138Stiffener · corrodedSTIFFENER CHANNEL CORRODED AT BS 1016, LOWER HOLE IN RT 186. REPAIRED STIFFENER IAW SRM.SDR SWAA2014031826195Bulkhead · corrodedAFT BULKHEAD CORRODED AT BS 1016, BL 0. REPAIRED BULKHEAD IAW EA.SDR SWAA2014021225090Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME INBD FLANGE CRACKED AT INNER RADIUS ADJACENT TO INBD LOWER CORNER OF BOTTOM STOP FITTING. R & R FRAME IAW ACO.SDR SWAA2014020424838Web · crackedAFT CARGO COMPARTMENT FWD SIDE OF DOOR CUTOUT CLOSE OUT WEB CRACKED. REPAIRED WEB IAW SRM.SDR SWAA2014012724578Angle · crackedFWD CARGO DOOR LOWER AFT CORNER MODIFICATION ANGLE CRACKED AT FASTENER. R & R DOOR IAW MM.SDR SWAA2013120923087Skin · crackedRT HORIZONTAL LOWER STAB SKIN AT AFT SPAR CRACKED. MEASURES 1.9 INCHES & IS 60 INCHES OTBD OF FUSELAGE. REPAIRED SKIN IAW SRM.SDR SWAA2013092620524Sign · brokenL1 DOOR EMERGENCY EXIT SIGN TAB BROKEN. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2013092620520Sign · looseR1 DOOR EMERGENCY EXIT SIGN LOOSE. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2013081419172Sign · missingR1 DOOR LIGHT SIGN MISSING. INSTALLED SIGN IAW SIP.SDR SWAA2013080918998Lens · unsecureR1 DOOR EMERGENCY EXIT LENS FELL OFF. INSTALLED LENS IAW SIP.SDR SWAA2013072318489Sign · looseFWD GALLEY EMERGENCY EXIT SIGN LOOSE. R&R SIGN IAW MM.SDR SWAA2013072618580Blower · overheatedPLASTIC SMELL IN COCKPIT & NORMAL EQUIP BLOWER CIRCUIT BREAKER TRIPPED. R&R EQUIP COOLING BLOWER IAW MM.SDR SWAA2013071518256Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL DOWN FROM CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2013062417477Sign · missingFORWARD ENTRY DOOR EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN IAW MM.SDR SWAA2013060616841Lens · brokenFWD ENTRY EMERGENCY EXIT LEN BROKEN OFF. R & R LENS IAW MM.SDR SWAA2013053016616Sign · looseFWD OVERHEAD EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW AMM.SDR SWAA2013031313587Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA2013030513342Mount · brokenEMERGENCY EXIT LIGHT ON GALLEY G-1 MOUNTING BASE IS BROKEN. REMOVED & REPLACED BASE IAW AMM.SDR SWAA2013022713149Stringer Clip · crackedSTRINGER CLIP AT STA 986, STR 2L IS CRACKED. REMOVED AND REPLACED CLIP IAW DWG & SRM.SDR SWAA2013022713148Stringer Clip · crackedSTRINGER CLIP AT STA 1006, STR 2.5R IS CRACKED. REMOVED AND REPLACED CLIP IAW BAC DWG & SRM.
Back to N605SW, cancelled Jul 27, 2018