N357SW, cancelled Mar 22, 2018
Service difficulty reports · 356
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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 SWAA2013121623343Floorbeam · corrodedFLOOR STRUCTURE BEAM CORRODED AT BS 344, BETWEEN LBL 7 & LBL 9. REPAIRED BEAM IAW SRM.SDR SWAA2013121623272Bulkhead · crackedDOME WEB CRACKED AT BS 1016, STRINGER 23L. REPAIRED WEB IAW SRM.SDR SWAA2013121623271Cover · brokenRT OVERWING EXTERNAL EMERGENCY EXIT LIGHT COVER BROKEN. R & R COVER IAW AMM.SDR SWAA2013121223257Tee Fitting · crackedR1 DOOR CUTOUT T FITTING CRACKED AT BS 334, STRINGER 8R. R & R T FITTING IAW SRM & DRAWING.SDR SWAA2013121223256Retainer · crackedFWD ENTRY DOOR CUTOUT CRACKED ON UPPER FWD CORNER RETAINER AT BS 312. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2013121123189Retainer · crackedFWD ENTRY DOOR CUTOUT IN FWD CABIN LOWER FWD CORNER RETAINER CRACKED AT BS 312. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2013121123188Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 10L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121123187Angle · crackedANGLE CRACKED AT BS 277+13, BETWEEN STRINGER 13R TO STRINGER 14R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121123186Strap · crackedFWD ENTRY DOOR LOWER HINGE CUTOUT CRACKED "H" STRAP BETWEEN BS 294.5 TO BS 303.9, STRINGER 13L. R & R "H" STRAP IAW SRM & DRAWING.SDR SWAA2013121123184Web · crackedWEB CRACKED BETWEEN BS 277 & BS 291.3, STRINGER 14R. R & R WEB IAW SRM & DRAWING.SDR SWAA2013121123183Web · crackedWEB CRACKED AT BS 294.5, STRINGER 11L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013120322949Angle · crackedANGLE CRACKED AT BS 328, RBL 31.5. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120322948Angle · crackedANGLE CRACKED AT BS 328, LBL 45. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121923527Skin · crackedRT WING LE CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2013121823477Web · crackedNLG WW CRACKED AT BS 243.7 +3.5, LBL 16.0. REPAIRED WEB IAW SRM.SDR SWAA2013121823476Web · crackedNLG WW CRACKED AT BS 243.7 +2.5, LBL 16.0. REPAIRED WEB IAW SRM.SDR SWAA2013121823475Web · crackedWEB CRACKED AT BS 706, LBL 46. REPAIRED WEB IAW EA.SDR SWAA2013121623341Door Frame · crackedAFT LOWER CORNER OF FRAME EDGE OF AFT CARGO DOOR CRACKED. R & R DOOR IAW AMM.SDR SWAA2013121623340Skin · crackedRT WING NR 6 SLAT INBD SIDE LOWER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013121623339Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 664, LBL 24.5+ 8. REPAIRED DECK IAW SRM.SDR SWAA2013121623338Support Angle · crackedSUPPORT ANGLE CRACKED AT INTERNAL AREA OF STRUT TORQUE BOX ACCESS 5757L NR 1 ENG. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121623337Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 661, BBL 0.07. REPAIRED CHORD IAW EA.SDR SWAA2013121623355Web · crackedWEB CRACKED ON INTERNAL STRUCTURE, 8" UP FROM AFT EDGE & 4" FROM AFT EDGE & 4" FROM AFT EDGE, AFT CARGO DOOR. R & R DOOR IAW AMM.SDR SWAA2013121623342Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED AT BS 664+2, LBL 24.5+8. REPAIRED DECK IAW SRM.SDR SWAA2013122023578Frame · crackedFUSELAGE BS 727 LT FRAME CHORD CRACKED AT STRINGER 18L TO STRINGER 27L. REPAIRED CHORD IAW SWA EA & EO.SDR SWAA2013122023577Stringer · crackedLT STRINGER 18A CRACKED AT BS 727. REPAIRED STRINGER IAW SWA EA & EO.SDR SWAA2013122023576Frame · crackedFUSELAGE BS 727 RT FRAME CHORD CRACKED AT STRINGER 18R. REPAIRED FRAME IAW SWA EA & EO.SDR SWAA2013121723417Skin · crackedSKIN CRACKED AT BS 706 + 10, LBL 5. REPAIRED SKIN IAW SRM.SDR SWAA2013120322923Light · dirtyEEPLS DIRTY. R & R EEPLS IAW MM.SDR SWAA2013081219016Glowstrip · dirtyRT PHOTOLUMINESCENCE STRIP DIRTY AT ROW 8. CLEANED EEPLS IAW STANDARD INDUSTRY PRACTICES.SDR SWAA2013081219015Web · crackedRT NOSE WW CRACKED AT STATION 259.5 - 1", WL 179. REPAIRED WEB IAW SRM.SDR SWAA2013080818956Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2013061817235Hinge Fitting · brokenRT WING I/B GROUND SPOILER O/B HINGE FITTING BROKEN. R&R GROUND SPOILER IAW MM.SDR SWAA2013053016613Battery · dischargedAFT INBD EMERGENCY FLASHLIGHT INOP. R & R BATTERY ASSY IAW MM.SDR SWAA2013030413233Attach Fitting · brokenLEFT WING GROUND SPOILER (NR 4) ATTACH FITTING BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA2012100108168Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+14, STR 1L. REPAIRED SKIN PER EA.SDR SWAA2012080706470Charger · inoperativeRIGHT EMERGENCY EXIT LIGHTS INOP BETWEEN ROW 21 TO ROW 23. REMOVED AND REPLACED CHARGER PER MM.SDR SWAA2012080706487Battery Pack · dischargedLEFT EMERGENCY EXIT LIGHT INOP BETWEEN ROW 21 TO ROW 23. REMOVED AND REPLACED BATTERY PACK PER M/M.SDR SWAA2012070905592Sign · looseLEFT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER M/M.SDR SWAA2012070605568Sign · looseLEFT OVERWING EMERGENCY EXIT SIGN LOOSE. REINSTALLED OVERWING EXIT SIGN PER MM.SDR SWAA2012052904392Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER MP.SDR SWAA2012051704082Lens · looseOVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2. SECURED LENS PER MM.SDR SWAA2012032902669Battery · dischargedLT OVERHEAD BULLNOSE EMERGENCY EGRESS LIGHTS INOP AT ROW 2. REMOVED & REPLACED BATTERY PER MM.SDR SWAA2012032902666Battery · dischargedRT OVERHEAD BULLNOSE EMERGENCY EGRESS LIGHTS INOP AT ROW 5. REMOVED & REPLACED BATTERY PER MM.SDR SWAA118293Slide · out of positionDURING SCHEDULED 20Y CHECK FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA118259Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 25L. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA118258Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO BAY I/B VERTICAL STIFFENER CRACKED AT BS 727, STR 27L. REPAIRED STIFFENER PER SRM.SDR SWAA118257Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA118241Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 18R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118240Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 25R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.
Back to N357SW, cancelled Mar 22, 2018