N673AA, cancelled Apr 21, 2009
Service difficulty reports · 199
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 = 'N673AA' AND deregistration_id = 'N673AA-2009-04-21' 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 = 'N673AA' AND deregistration_id = 'N673AA-2009-04-21' 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 SWAA001701Light · looseEEPLS LOOSE AT OVERWING EXIT. SECURED LIGHTS.SDR SWAA001529Light · inoperativeTHREE EEPLS INOP. RELAMPED AND REMOVED AND REPLACED TRACK COVER PER MM.SDR SWAA001247Girt Bar · out of adjFWD SERVICE DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUSTMENT. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000934Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE EXTERNAL SKIN HAS A 3 INCH LONG CRACK, BS 942, STRINGER 25R. REPAIRED SKIN PER SRM.SDR SWAA000760Indicator · inoperativeABORTED TAKEOFF, NR 2 ENG N1 INDICATOR INOP DURING TAKEOFF AT 25 KNTS. REMOVED AND REPLACED NR 2 ENG N1 INDICATOR PER MM.SDR SWAA000664Light · inoperativeEEPLS LIGHT INOP AT OVERWING EXIT. R&R LIGHT ASSY PER MM.SDR SWAA000490Battery · inoperativeDURING SCHEDULED C4 CHECK, FOUND OVERHEAD EMERGENCY LIGHT INOP AT ROW 18. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA000218Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP ON AFT END. REMOVED AND REPLACED LIGHT BULB AND COVER ASSY PER MM.SDR SWAA000018Light · inoperativeEEPLS INOP BY OVERWING EXIT. RELAMPED PER MM..SDR SWAA992035Lens · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS LENS MISSING AT MID CABIN. REPLACED LENS ASSY PER MM.SDR SWAA991452Slide · low pressFWD SERVICE DOOR EVACUATION SLIDE PRESS OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA991435Lens · brokenDURING SCHEDULED C2 CHECK, FOUND LT AND RT OVERWING EMERGENCIY EXIT SIGN LENSES BROKEN. REMOVED AND REPLACED BOTH LENSES PER MM.SDR SWAA990145Fan · failedDURING SCHEDULED 1/2D CHECK, NOTED A SMOKE SMELL WITH RECIRCULATING FAN RUNNING. REMOVED AND REPLACED FAN PER BOEING MM.SDR SWAA990121Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED UNDER STRAP AT BS 727D + 6, LBL 17. REPAIRED PER SWA RA 1-353-1979.SDR SWAA990084Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND A 1.5 INCH CRACK AT AFT LOWER CORNER OF FWD SERVICE DOOR. REPAIRED PER SWA RA 1-353-1970.SDR SWAA990083Bulkhead Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND A CRACK IN WEB AT BS 178, RBL 1.0. REPAIRED PER BOEING SRM.SDR SWAA990082Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 802, RBL 14. REPAIRED PER BOEING SRM.SDR SWAA990067Chord · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT CHORD CRACKED AT BS 178, LBL 29. REPAIRED PER BOEING SRM.SDR SWAA990066Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 940 TO 947, LBL 17. CUT OUT AND SPLICED IN REPAIR PER BOEING SRM.SDR SWAA990065Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CRACKED AT BS 360, AT S11L. REPLACED DAMAGED SECTION PER BOEING SRM.SDR SWAA990064Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CRACKED AT BS 360, AT S15L. REPLACED DAMAGED SECTION PER BOEING SRM.SDR SWAA990063Bulkhead Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT LBL 4.5. REPAIRED PER BOEING SRM.SDR SWAA990062Frame · gougedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME GOUGED AT BS 700, AT LBL 60. REPLACED PER BOEING SRM.SDR SWAA990056Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD CRACKED AT RBL 7.0. REPAIRED PER BOEING SRM.SDR SWAA990055Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 727D+6, LBL 3 AND 8. REPAIRED PER SWA RA 1-353-1972.SDR SWAA990054Bulkhead Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD WEB CRACK AT LBL 10 AND RBL 10, WL 234. REPAIRED PER BOEING SRM.SDR SWAA990026Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED UNDER STRAP AT BS 727D PLUS 6 RBL 8 AND LBL 13. REPAIRED PER SWA RA 1-353-1972.SDR SWAA990025Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED NEAR Z ANGLE AT AFT ENTRY DOOR. REPLACED T CHORD PER BOEING SRM.SDR SWAA990024Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT FWD FLANGE LOWER SURFACE, BS 1016. REPAIRED PER BOEING SRM.SDR SWAA990023Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 663, AT S10L AND R. REPAIRED PER BOEING SRM.SDR SWAA990022Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5. REPLACED T-CHORD PER BOEING SRM.SDR SWAA990021Bulkhead Web · corrodedDURING SCHEDULED 1/2D CHECK, FOUND NUMEROUS CRACK LOCATIONS IN WEB AT BS 178. REPAIRED PER BOEING SRM.SDR SWAA990020Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT FASTENER HOLE AND UPPER CHORD, BS 312. REPAIRED PER BOEING SRM.SDR SWAA990001Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 26R AT AFT GALLEY CORRODED. REPLACED DAMAGED SECTION PER BOEING SRM.SDR SWAA983063Pin · unsecuredLOUD NOISE FROM FWD ENTRY DOOR AFTER TAKEOFF. AIRCRAFT RETURNED TO BWI, FOUND HINGE PIN OUT AT UPPER HINGE COVER. RESECURED COVER.SDR SWAA982990Wire · failedDURING SCHEDULED A1 CHECK, FOUND EMERGENCY TRACK LIGHTS INOP FROM ROWS 1 TO 8. REPLACED TRACK WIRE AND OP CHECKED PER BOEING M/M.SDR SWAA982771Light · inopDURING SCHEDULED C3 CHECK, FOUND SEVERAL LIGHTS INOPERATIVE ON AFT END OF EMERGENCY LIGHTS STRIP. RELAMPED LIGHTS AT END OF STRAP PER BOEING MM.SDR SWAA980056Actuator · failedON CLIMB-OUT AFTER GEAR RETRACTION, LEFT MAIN GEAR EXTENDED WITH HANDLE IN UP POSITION. REPLACED LEFT MAIN GEAR UPLOCK ACTUATOR PER BOEING M/M.SDR SWAA971020Light · inoperativeDURING WALKAROUND CHECK, FOUND 1 SECTION OF EMERGENCY TRACK LIGHTING INOP. REPLACED LIGHT ASSEMBLY PER BOEING M/M.SDR SWAA970990Strap · crackedDURING SCHEDULED C3 CHECK, FOUND STRAP BY AFT ENTRY DOOR CRACKED 1.25 INCH THROUGH LOCK. REPAIRED PER BOEING SRM.SDR SWAA970787Slide · low pressDURING SERVICE CHECK, FOUND R2 DOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR SWAA970697Light · inoperativeDURING C2 CHECK, FOUND ONE RED FLOOR TRACK LIGHT INOP. REPLACED PER BOEING M/M.SDR SWAA970669Light · looseDURING RON CHECK, FOUND FLOOR TRACK LIGHT LOOSE FROM FLOOR AT ROW 1. REINSTALLED PER BOEING SRM.SDR SWAA961419Relay · failedRETURNED TO MCI DUE TO NUMBER 1 TRANSFER C/B TRIPPING IN FLIGHT. REPLACED R3 RELAY AND OP CHECKED PER BOEING M/M.SDR SWAA961329Skin · dentedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN DENTED 6 INCHES ABOVE STRINGER 24 AT FRAME, BS 194. REPAIRED PER BOEING SRM.SDR SWAA961343Skin · bird strikeAFTER TAKEOFF, LARGE BIRD OR BIRDS HIT NEAR LEFT NOSE WHEEL WELL. AIRCRAFT RETURNED TO DAL AND MADE AN UNEVENTFUL LANDING. INSPECTED AND FOUND SLIGHT EVIDENCE OF STRIKE TO NOSE LEFT SIDE, WITHIN BOEING SRM AND NUMBER 1 ENGINE. BORESCOPED AND PERFORMED ENGINSDR SWAA961114Transmitter · failedON CLIMBOUT, FLAPS WOULD NOT RETRACT PAST 2 UNITS, SPILT INDICATION. AIRCRAFT DIVERTED TO OAK AND MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED RT FLAP POSITION TRANSMITTER AND OP CHECKED PER BOEING M/M.SDR SWAA960809Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN S27R AND S27L. REPAIRED PER BOEING SRM.SDR SWAA950511Door Warning · malfunctionedABORTED TAKEOFF DUE TO MASTER CAUTION INDICATING FWD ENTRY DOOR OPEN. RETURNED TO GATE. INSPECTED AND FOUND DOOR SECURED AND LOCKED. PLACED DOOR WARNING ON MEL 52-2. INSPECTED TIRES/BRAKES AND CONTINUED PER BOEING M/M.
Back to N673AA, cancelled Apr 21, 2009