N129SW, cancelled Mar 14, 2005
Service difficulty reports · 144
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 = 'N129SW' AND deregistration_id = 'N129SW-2005-03-14' 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 = 'N129SW' AND deregistration_id = 'N129SW-2005-03-14' 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 SWAA002197Slide · dislodgedFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA002137Indicator · out of positionAFT ENTRY EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001982Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND EEPLS TRACK RED LIGHT INOP, AFT CABIN, 2ND FROM REAR.SDR SWAA001981Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. ADJUSTED SLIDE ASSY PER MM.SDR SWAA001623Skin · crackedDURING THRU FLIGHT CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 835, STRINGER 25L, AND BS 787, STRINGER 22L. REPAIRED CRACKS PER SRM.SDR SWAA001429Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA001226Cover · missingDURING SCHEDULED C1 CHECK, FOUND EEPLS AFT END CAP MISSING. R&R END CAP PER MM.SDR SWAA001100Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED 1.5 INCH LONG, BS 899 STRINGER 24R. REPAIRED SKIN PER SRM.SDR SWAA000687Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. R & R BATTERY PACK PER MM.SDR SWAA000634Cover · looseEEPLS TRACK COVER LOOSE. SECURED TRACK COVER PER MM.SDR SWAA000645Light · looseEEPLS TRACK COVER SECTION LOOSE . SECURED AND RELAMPED TRACK SECTION PER MM.SDR SWAA000318Cover · looseEEPLS TRACK COVER LOOSE AT MID CABIN. SECURED TRACK COVER PER MM.SDR SWAA000297Indicator · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000284Cover · looseEEPLS TRACK COVER LOOSE. SECURED TRACK COVER PER MM.SDR SWAA000247Battery · dischargedDURING SCHEDULED D-CHECK, FOUND BOTH FWD EVACUATION SLIDE EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA000246Switch · inoperativeDURING SCHEDULED D-CHECK, FOUND AFT EEPLS SWITCH INOP. REMOVED AND REPLACED SWITCH PER MM.SDR SWAA000185Keel Beam · corrodedDURING SCHEDULED D CHECK, FOUND KEEL BEAM WEB CORRODED, BS 571-587. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA000102Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER 15L CRACKED, BS 1011. REPAIRED STRINGER PER SRM.SDR SWAA000091Lug · crackedDURING SCHEDULED D CHECK, FOUND LT HORIZONTAL STAB REAR SPAR UPPER LUG BORE CORRODED AND CRACKED AT 1 AND 9 O'CLOCK POSITIONS. REPAIRED LUG PER ER NR 99-6540.SDR SWAA000043Stringer · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER 26R CORRODED, BS 793. REPAIRED STRINGER PER SRM.SDR SWAA000022Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 1016, RBL 13 TO RBL 35. REPAIRED BEAM PER SRM.SDR SWAA992148Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 907, STRINGER 27L. REPAIRED FRAME PER SRM.SDR SWAA992147Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STUB FRAME CRACKED, BS 578, LBL 60 AND LBL 63. REPAIRED STUB FRAME PER SRM.SDR SWAA992118Flap Track · corrodedDURING SCHEDULED D-CHECK, FOUND PITTING CORROSION AT NR 1 AND NR 8 T/E FLAP TRACKS AFT MOUNTING SURFACES. REMOVED AND REPLACED FLAP TRACKS PER MM AND ACO.SDR SWAA992098Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 FUSELAGE FRAMES CRACKED, BS 639, STRINGER 17R AND BS 303, STRINGER 18L. REPAIRED FRAMES PER SRM.SDR SWAA992096Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED, RBL 7. REPAIRED BULKHEAD PER SRM.SDR SWAA992085Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME CORRODED, BS 767, WL 150. REPAIRED FRAME PER SRM.SDR SWAA992063Skin · delaminatedDURING SCHEDULED D CHECK, FOUND LT AND RT WING T/E INBOARD FORE FLAPS DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED BOTH FORE FLAP ASSY'S PER MM.SDR SWAA992055Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED, BS 727B, RBL 12, WL 150. REPAIRED FRAME PER SRM.SDR SWAA992043Skin · delaminatedDURING SCHEDULED D CHECK, FOUND LEFT INBOARD T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA991970Slide · wornDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT VELCRO WORN. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991969Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 727, BELOW NR 21 AND NR 22 WINDOWS. REPAIRED SKIN PER SRM.SDR SWAA991900Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN OVERHEAD EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA991821Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT ENTRY AND SERVICE DOORS EXTERIOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA991524Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND BOTH AFT CABIN DOORS EXTERIOR EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA990840Slide · out of positionAFT SERVICE DOOR ESCAPE SLIDE GAUGE OUT VIEW. REPOSITIONED SLIDE ASSY AS REQUIRED PER MM.SDR SWAA990720Bulkhead · crackedDURING SCHEDULED C1 CHECK, FOUND BS 178 BULKHEAD CRACKED BELOW RADAR RT MOUNT, BL 0. REPAIRED PER SRM.SDR SWAA990238Battery · dischargedDURING SCHEDULED CHECK, FOUND AFT EMERGENCY FLOOR EGRESS LIGHTS INOP. REMOVED AND REPLACED AFT EGRESS BATTERY PACK AND CHARGER, OPS CK'D OK PER M/M.SDR SWAA990130Skin · crackedDURING SCHEDULED SC CHECK, FOUND FUSELAGE SKIN CRACKED APPROX 4 INCHES , LEFT SIDE AFT OF WING AND DIRECTLY BEHIND PREVIOUS REPAIR. REPAIRED PER BOEING SRM.SDR SWAA990098Battery · dischargedDURING SCHEDULED SC CHECK, FOUND EMERGENCY EXIT LIGHTS INOP, FLOOR LIGHTS FROM ROW 16 TO AFT, AND AFT ENTRY AND SERV DOOR LOWER EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA990058Slide · low pressureDURING PREFLIGHT CHECK, FOUND AFT ENTRY DOOR SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER BOEING M/M.SDR SWAA990019Battery · dischargedDURING SCHEDULED SC CHECK, FOUND AFT SECTION OF EMERGENCY TRACK LIGHTING INOP. REMOVED AND REPLACED BATTERY PACK PER M/M.SDR SWAA990007Battery · dischargedDURING SCHEDULED SC CHECK, FOUND SEVERAL AFT CABIN FLOOR TRACK EMERGENCY LIGHTS INOP. REMOVED AND REPLACED POWER SUPPLY AND OP CHECKED PER BOEING M/M.SDR SWAA983122Outflow Valve · failedPRESSURIZATION AUTO FUNCTION FAILED ON DEPARTURE. CABIN PRESSURE CLIMBED TO 2,000 FT MINUTE. SWITCHED TO STBY, CABIN RECOVERED. OK TO CONTINUE PER MEL 21-14 AND SPECIAL PROCEDURE. REPLACED MAIN (AFT) OUTFLOW VALVE, SYSTEM OPS CK'D PER M/M. TAG (P/N 98734SDR SWAA983061Battery · dischargedDURING SCHEDULED CHECK, FOUND AFT SECTION OF FLOOR TRACK EMERG LIGHTING INOP. REMOVED AND REPLACED AFT FLOOR TRACK LIGHT BATTERY PACK PER M/M.SDR SWAA982994Skin · crackedDURING SCHEDULED CHECK, FOUND FUSELAGE SKIN CRACKED ON RT SIDE AFT AND ABOVE WING. REPAIRED PER BOEING SRM.SDR SWAA982935Skin · crackedDURING WALKAROUBD CHECK, FOUND FUSELAGE SKIN CRACK RT SIDE AFT ABOVE AFT WING BODY FAIRING. REPAIRED PER BOEING SRM.SDR SWAA982701Csd · reqd serviceTAKEOFF REJECTED AT 40KTS FOR NR 1 CSD LOW OIL PRESSURE LIGHT. RETURN TO GATE. SERVICED NR 1 CSD AND LEAK CHECKED PER BOEING MM. (LPG 40946)SDR SWAA982645Light · looseDURING WALKAROUND CHECK, FOUND AFT SERVICE DOOR EMERGENCY EXIT LIGHT OPERATING INTERMITTENTLY. RESECURED LIGHT ASSEMBLY AND OP CHECKED PER BOEING M/M.SDR SWAA981619Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 374 STR 15L. REPAIRED PER BOEING SRM.
Back to N129SW, cancelled Mar 14, 2005