N710SW, cancelled Nov 7, 2024
Service difficulty reports · 238
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 = 'N710SW' AND deregistration_id = 'N710SW-2024-11-07' 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 = 'N710SW' AND deregistration_id = 'N710SW-2024-11-07' 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 SWAA2019092637232Cover · missingLT EMERGENCY LIGHT LENS COVER MISSING ABOVE SEAT ROW 9. INSTALLED COVER PER SIP.SDR SWAA2019082236207Battery Pack · inoperativeR/H FORWARD EMERGENCY LIGHTS INOP. R&R BATTERY PACK IAW AMM.SDR SWAA2019082236201Power Supply · inoperativeR/H FORWARD EMERGENCY LIGHTS INOP. R&R POWER SUPPLY IAW AMM.SDR SWAA2019071935095Retaining Clip · looseR1 DOOR SLIDE RETENTION CLIP LOOSE. ADJUSTED CLIP PER SIP.SDR SWAA2019050632317Switch · faultyAIR TURNBACK, ON TAKEOFF MASTER CAUTION LIGHT ILLUMINATED WITH STANDBY RUDDER ON LIGHT ILLUMINATED. R&R SWITCH PER AMM.SDR SWAA2019050632316Control Panel · faultyAIR TURNBACK, ON TAKEOFF MASTER CAUTION LIGHT ILLUMINATED WITH STANDBY RUDDER ON LIGHT ILLUMINATED. R&R FLIGHT CONTROL PANEL PER AMM.SDR SWAA2018092425441Spoiler · damagedLT WING NR 6 INBOARD SPOILER DAMAGED. R&R NR 6 GROUND SPOILER PER AMM.SDR SWAA2018092425442Skin · crackedFUSELAGE SKIN CRACKED AT BS 727A+9, STR 1L. REPAIRED SKIN PER EA.SDR SWAA2018082824631Cover · looseL1 DOOR SLIDE MANUAL INFLATION HANDLE LOOSE. REATTACHED COVER IAW AMM.SDR SWAA2018072623838Sensor · faultyDIVERSION, LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED. R&R NR 6 SLAT INBOARD SENSOR PER AMM.SDR SWAA2018071123377Sign · brokenRT EXIT ROW EMERGENCY LIGHT BROKEN OFF. R&R SIGN ASSEMBLY PER AMM.SDR SWAA2018062522963Girt Bar · looseL2 DOOR EMERGENCY SLIDE LOOSE. SECURED GIRT BAR PER MM.SDR SWAA2018043021464Lens · missingRT OUTERWING EMERGENCY LENS COVER MISSING. R&R COVER PER SIP.SDR SWAA2018021419642Floorbeam · crackedAFT CARGO FLOORBEAM CRACKED AT BS 727E, RBL 13.8. R & R THE FLOORBEAM IAW SRM.SDR SWAA2017091916441Intercostal · crackedFORWARD CARGO INTERCOSTAL CRACKED AT BS 520, STR 25R. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2017092716661Rib · crackedLT HORIZONTAL STABILIZER RIB CRACKED AT STA 129.5, 3RD STIFFENER AFT. REPAIRED RIB IAW SRM, ER, AND EA.SDR SWAA2017091216303Intercostal · crackedINTERCOSTAL CRACKED AT BS 303.9, STR 4L. REPAIRED INTERCOSTAL PER DWG & SRM.SDR SWAA2017090716178Rib · crackedRIGHT HORIZONTAL STABILIZER LEADING EDGE 341B RIB CRACKED AT HSS 151.75 LOWER AFT END. R & R THE RIB IAW SRM & DWG.SDR SWAA2017090716177Rib · crackedLEFT HORIZONTAL STABILIZER LEADING EDGE 331B RIB CRACKED AT HSS 114.0, AT LOWER AFT END. REPAIRED THE RIB IAW SRM & DWG.SDR SWAA2017090816211Attach Fitting · crackedFIXED FORWARD BODY FAIRING SUPPORT ATTACH FITTING CRACKED AT BS 500, STRINGER 18L. R & R THE ATTACH FITTING IAW SRM AND DWG.SDR SWAA2017090716176Gusset · crackedFORWARD CARGO GUSSET CRACKED AT BS 500D, STRINGER 19L. R & R GUSSET IAW SRM AND DWG.SDR SWAA2017090716175Gusset · crackedFORWARD CARGO GUSSET CRACKED AT BS 500D, STRINGER 19R. R & R THE GUSSET IAW DWG AND SRM.SDR SWAA2017101617089Slat · crackedLEFT WING NR 2 SLAT CRACKED AT ACTUATOR RIBS. REPAIRED THE SLAT IAW EA AND ER.SDR SWAA2017101016998Slat · crackedLT WING NR 1 SLAT CRACKED AT ACTUATOR RIBS. R&R NR 1 SLAT ASSEMBLY IAW AMM.SDR SWAA2017081515674Sign · brokenL1 DOOR LOWER FORWARD BULKHEAD EXIT SIGN BROKEN. REPAIRED SIGN PER EA.SDR SWAA2017061914431Girt Bar · out of positionL1 DOOR EMERGENCY EVAC SLIDE GIRT OUT OF POSITION. R&R GIRT IAW MT.SDR SWAA2017030312296Skin · delaminatedRIGHT WING OUTBOARD AFT FLAP DELAMINATED. R & R AFT FLAP PER AMM.SDR SWAA2017030312295Battery Pack · no testAFT LEFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY FUNCTIONAL TEST. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016121510520Lens · brokenAFT ENTRY EXIT LENS COVER BROKEN. R&R COVER ASSEMBLY PER AMM.SDR SWAA2016111009582Cover · crackedL1 DOOR EMERGENCY EXIT SIGN COVER CRACKED. R & R THE SIGN IAW AMM.SDR SWAA2016082555157Strap · brokenFORWARD GALLEY EMERGENCY FLASHLIGHT STRAP BROKEN. R & R THE FLASHLIGHT STRAP IAW AMM.SDR SWAA2016082455100Angle · looseR2 DOOR EMERGENCY SLIDE ANGLE LOOSE. SECURED THE ANGLE IAW SIP AND AMM.SDR SWAA2016042751358Transmitter · faultyDIVERSION, SYS A HYD QTY SLOWLY DROPPED FROM 65% TO 57% OVER A 20 MINUTE PERIOD AT CRUISE. SUSPECTED SYS A HYD LEAK. R & R A SYS QTY TRANSMITTER IAW MM.SDR SWAA2016020148551Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 986, STRINGER 18L. R & R CLIP IAW SRM & DWG.SDR SWAA2016021148981Rib · crackedLEFT WING REAR SPAR, DEFLECTION RIB BETWEEN INBD & OTBD FLAPS CRACKED. R & R RIB IAW SRM.SDR SWAA2016012548360Support Angle · crackedLEFT WING FIXED TE, INBD SIDE OF INBD FLAP, ROLLER TRACK SUPPORT ANGLE CRACKED. R & R CLIP IAW SRM & DWG.SDR SWAA2016020348648Threshold · corrodedAFT CARGO COMPARTMENT THRESHOLD WEB CORRODED, AT BS 794, RBL 20. R & R WEB IAW DWG.SDR SWAA2016012748417Support · crackedAFT CARGO COMPARTMENT CLIP SUPPORT CRACKED AT BS 807, RBL 20. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016020348647Crease Beam · corrodedLEFT SIDE CREASE BEAM CHORD CORRODED, BETWEEN BS 947.5 - 998. R & R CHORD IAW DWG.SDR SWAA2016020348646Crease Beam · corrodedRIGHT SIDE CREASE BEAM CHORD CORRODED, BETWEEN BS 938 - 998. R & R CHORD IAW DWG.SDR SWAA2016012548359Intercostal · crackedINTERCOSTAL CRACKED, BETWEEN BS 344 - 360, LBL 11. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016012048203Intercostal · crackedMAIN CABIN INTERCOSTAL CRACKED, BETWEEN BS 312 - 328, RBL 32. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016021849154Web · crackedVERTICAL WEB CRACKED AT BS 663, RBL 25 - 45. REPAIRED WEB IAW SRM.SDR SWAA2016021649136Pressure Panel · crackedHORIZONTAL PRESS WEB CRACKED AT BS 663, BETWEEN RBL 25 - 45. REPAIRED WEB IAW EA.SDR SWAA2016021649135Pressure Panel · crackedHORIZONTAL PRESS WEB CRACKED AT BS 663, BETWEEN LBL 25 - 45. REPAIRED WEB IAW EA.SDR SWAA2016021148980Frame · crackedLOWER FRAME WEB CRACKED AT BS 727, WL 200. REPAIRED WEB IAW EA.SDR SWAA2016020448690Skin · crackedRT WING SLAT SKIN CRACKED AT STA 322.11. REPAIRED SLAT IAW SRM.SDR SWAA2016012148226Intercostal · crackedFORWARD WET AREA MAIN CABIN INTERCOSTAL CRACKED, BETWEEN BS 294 - 312, RBL 16. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2016012148225Fitting · corrodedL1 DOOR FWD FLOOR MOUNT GIRT FITTING CORRODED. R & R FITTING IAW SRM & DWG.SDR SWAA2016012048202Intercostal · crackedFORWARD WET AREA INTERCOSTAL CRACKED, BETWEEN BS 312 - 328, LBL 45.60. R & R INTERCOSTAL IAW SRM & DWG.
Back to N710SW, cancelled Nov 7, 2024