N795SW, cancelled Oct 28, 2024
Service difficulty reports · 192
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 = 'N795SW' AND deregistration_id = 'N795SW-2024-10-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 = 'N795SW' AND deregistration_id = 'N795SW-2024-10-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 SWAA2016111709810Bulkhead · crackedLOWER BULKHEAD CHORD CRACKED AT BS 540, LT SIDE. REPAIRED CHORD PER EA.SDR SWAA2016111709809Skin · corrodedFUSELAGE SKIN UNDER DORSAL FIN CORRODED. R&R SKIN PER ER & EA.SDR SWAA2016111409674Frame · crackedLOWER FRAME WEB CRACKED AT BS 727, WL 200. REPAIRED WEB PER EA.SDR SWAA2016111709808Door Sill · corrodedLT OVERWING EMERGENCY EXIT CUTOUT LOWER SILL WEB CORRODED AT UPPER SURFACE. REPAIRED WEB PER SRM.SDR SWAA2016111409673Web · corrodedRT OVERWING EMERGENCY EXIT CUTOUT LOWER SILL WEB CORRODED AT UPPER SURFACE. REPAIRED WEB PER SRM.SDR SWAA2016082555137Cover · missingR2 DOOR EMERGENCY EXIT SIGN COVER MISSING. INSTALLED COVER IAW AMM.SDR SWAA2016080454534Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE COVER OUT OF POSITION. REPOSITIONED SLIDE IAW MAINTENANCE.SDR SWAA2016051751879Cover · looseRIGHT SIDE OVERWING EMER EXIT SIGN COVER LOOSE. SECURED COVER IAW EA.SDR SWAA2016041450879Actuator · crackedRIGHT WING NR 6 LE SLAT ACTUATOR CRACKED. R & R ACTUATOR IAW AMM.SDR SWAA2015031837555Slide · looseR2 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2015022336838Flap · crackedRIGHT WING INBD FLAP SECONDARY TORQUE TUBE AFT ATTACHMENT HOLE CRACKED. R & R FLAP IAW SRM & EA.SDR SWAA2015020236262Floorbeam · crackedFLOORBEAM VERTICAL WEB AT CRACKED AT BS 727C, RBL 24.75 LOWER FASTENER HOLE. REPAIRED WEB IAW EA & SWA EA.SDR SWAA2015020236261Rib · crackedRIGHT HORIZONTAL STABILIZER RIB STATION 147.9 CRACKED FASTENER HOLE 32 INCHES FROM FWD SPAR INBD. REPAIRED RIB IAW EA.SDR SWAA2015020236260Rib · crackedRIGHT HORIZONTAL STABILIZER RIB STATION 147.9 CRACKED AT FASTENER HOLE 17.25 INCHES FROM FWD SPAR OTBD FLANGE. REPAIRED RIB IAW EA.SDR SWAA2015012636097Rib · crackedRIGHT HORIZONTAL STABILIZER STATION 129.5, RIB CRACKED IN VERTICAL STIFFENER 1ST ONE FROM FRONT, 1 INCH UP FROM BOTTOM OF RIB. REPAIRED RIB IAW SRM.SDR SWAA2015012636096Rib · crackedRIGHT HORIZONTAL STABILIZER STATION 101.9, RIB CRACKED IN VERTICAL STIFFENER 1ST ONE FROM FRONT, 1 INCH UP FROM BOTTOM OF RIB. R & R RIB IAW SRM.SDR SWAA2015012636095Rib · crackedRIGHT HORIZONTAL STABILIZER STATION 92.7, RIB CRACKED IN VERTICAL STIFFENER 3RD FROM FRONT, 1 INCH UP FROM BOTTOM OF RIB. REPAIRED RIB IAW SRM.SDR SWAA2015020236259Floorbeam · crackedFLOORBEAM CHORD CRACKED AT BS 727B, RBL 24.75. REPAIRED FLOORBEAM IAW EA.SDR SWAA2015020236258Seat Track · crackedFORWARD SEAT TRACK, INBD & OTBD FLANGE CRACKED AT BS 727B, RBL 24.75 FASTENER HOLES. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015020236257Window Frame · crackedRIGHT NR 3 WINDOW FRAME FASTENER HOLE, NR 2 FROM BOTTOM CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2015020236256Window Frame · crackedLEFT NR 3 WINDOW FRAME FASTENER HOLE, NR 3 FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2015020236273Window Frame · crackedLEFT NR 3 WINDOW FRAME SECOND FROM BOTTOM FASTENER HOLE CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2015013036239Seat Track · crackedFORWARD SEAT TRACK INBD & OTBD FLANGE CRACKED AT BS 727B, LBL 24.75 FASTENER HOLES. REPAIRED FLANGE IAW EA & SWA EA.SDR SWAA2015013036238Seat Track · crackedFORWARD SEAT TRACK, INBD & OTBD FLANGE CRACKED AT BS 727B, RBL 45.5 FASTENER HOLES. REPAIRED TRACK IAW EA.SDR SWAA2015013036237Seat Track · crackedFORWARD SEAT TRACK, INBD & OTBD FLANGE CRACKED AT BS 727B, LBL 45.5 FASTENER HOLES. REPAIRED SEAT TRACK IAW EA.SDR SWAA2015012936188Window Frame · crackedRIGHT NR 1 WINDOW FRAME CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2015020236272Flap · delaminatedRIGHT WING OTBD AFT FLAP INBD CORNER DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2015010235407Lens · unsecureOVERHEAD MID CABIN EXIT SIGN COVER FELL OFF. SECURED LENS COVER IAW MM.SDR SWAA2014100832774Tire · failedAIR TURN BACK DECLARED EMER TIRE FAILURE ON TAKEOFF. R & R NR 4 MAIN TIRE IAW MM.SDR SWAA2014050827794Battery · failedCEILING AFT ENTRY EMERGENCY LIGHTS BATTERIES FAILED CAPACITY TEST. R & R BATTERIES IAW TC & WDM.SDR SWAA2014050827818Post · crackedCAPTAIN`S C & D WINDOW POST CRACKED. REPAIRED POST IAW EA.SDR SWAA2014050827817Battery · failedMID CABIN EMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST. R & R BATTERIES IAW TC & WDM.SDR SWAA2014020324808Cover · brokenR1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R & R LIGHT ASSEMBLY IAW SIP.SDR SWAA2013091320122Battery · failedRT EMERGENCY EXIT BATTERIES FAILED CAPACITY TEST. R&R BATTERIES IAW AMM.SDR SWAA2013091320121Retaining Clip · looseL1 DOOR EMERGENCY EVAC SLIDE COVER AFT GIRT BAR RETAINING CLIP LOOSE. SECURED CLIP IAW SRM.SDR SWAA2013082619574Charger · inoperativeRT EMERGENCY EXIT INOPERATIVE. R&R CHARGER ASSEMBLY IAW AMM.SDR SWAA2013070317884Slide · out of positionR 2 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2013070217871Sign · brokenR1 DOOR EMERGENCY EXIT SIGN BROKEN. R&R SIGN ASSEMBLY IAW AMM.SDR SWAA2013021412681Slide · out of positionFORWARD ENTRY ESCAPE SLIDE APPEARS TO BE HANGING LOWER THAN NORMAL. REMOVED SLIDE (L-1) REPOSITIONED SLIDE AND ADJUSTED GIRT LENGTHS AND REINSTALLED PER MT 725-61-06. CHECK'S OK.SDR SWAA2013012911996Battery Pack · failedFORWARD LEFT EMERGENCY EXIT LIGHT BATTERY PACK FAILED 15 MINUTES MINIMUM BLEED DOWN TEST. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2013012311757Fitting · crackedAFT CARGO, STA 727 RBL 6, APU "LOWER" DUCT PANEL SUPPORT HAS CRACKED CLIP. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013012311756Fitting · crackedAFT CARGO, STA 860 LBL 12, CLIP CRACKED BELOW THE FWD INBOARD LAV TANK COMPARTMENT POST. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013012311758Beam · crackedLEFT WING, O/B FLAP WELL, I/B CLOSEOUT PANEL ATTACH BEAM IS CRACKED AT THE I/B SIDE. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA2013011511454Intercostal · damagedINTERCOSTAL WEB DAMAGED STA 500D+17 BL 0 TO LBL 24. REMOVED AND REPLACED INTERCOSTAL PER SRM.SDR SWAA2013011511445Intercostal · tornINTERCOSTAL BETWEEN THE NR 1 AND NR 2 SEAT TRACK UPPER WEB TORN OFF STA 500D+17. RE-INSTALLED WEB PER SRM.SDR SWAA2013011811574Frame · crackedFUSELAGE FRAME HAS CRACK INDICATION (HFEC) AT STA 440, STR 8R (I/B HOLE, AFT SIDE OF FRAME). REPAIRED FRAME PER EA.SDR SWAA2013011811573Frame · crackedFUSELAGE FRAME HAS CRACK INDICATION (HFEC) AT STA 400, STR 8R (I/B HOLE, AFT SIDE OF FRAME. REPAIRED FRAME PER EA.SDR SWAA2013011811572Frame · crackedFUSELAGE FRAME HAS CRACK INDICATION (HFEC) AT STA 480, STR 8R (I/B HOLE, AFT SIDE OF FRAME. REPAIRED FRAME PER EA.SDR SWAA2013011611457Frame · crackedFUSELAGE FRAME HAS CRACK INDICATION (HFEC) AT STA 360, STR 8R (I/B HOLE, AFT SIDE OF FRAME). REPAIRED PER EA.SDR SWAA2013011511446Frame · crackedFUSELAGE FRAME HAS CRACK INDICATION (HFEC) AT STA 747, SR 8L (I/B HOLE, AFT SIDE OF FRAME). REPAIRED FRAME PER EA.
Back to N795SW, cancelled Oct 28, 2024