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 SWAA031627Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031650Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA031609Fitting · corrodedDURING SCHEDULED D CHECK, FOUND RT HORIZ STAB HINGE FITTING LOWER AND UPPER LUGS CORRODED. REPAIRED LUGS PER SRM.SDR SWAA031601Keelbeam · corrodedDURING SCHEDULED D CHECK, FOUND KEELBEAM CORRODED BETWEEN BS 500D + 2 AND BS 500D + 6, WL 147 AND RBL 7. REPAIRED KEEL BEAM PER SRM.SDR SWAA031631Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIES CRACKED (2 EA) AT BS 360 BETWEEN STR 14R AND STR 15R, BS 400 BETWEEN STR 13L AND STR 14L. REPAIRED SHEAR TIES PER SRM.SDR SWAA031600Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 827, WL 148 AT LBL 17. REPAIRED SHEAR TIE PER SRM.SDR SWAA031599Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L AND STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA031566Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, WL 208 AND LBL 17 TO RBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA031560Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 787, WL 148 AND RBL 9. REPAIRED SHEAR TIE PER SRM.SDR SWAA031561Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND RT CREASE BEAM CORRODED AT BS 638, BS 907 AND BS 946. REPAIRED CREASE BEAM PER SRM.SDR SWAA031552Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA031565Stringer · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CRACKED AT BS 1011, STR 7L. REPAIRED STRINGER PER SRM.SDR SWAA031537Frame · crackedDURING SCHEDULED D CHECK, FOUND RT BS 188 CHORD CRACKED AT WL 207. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA031536Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031550Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICES CRACKED (2 EA) AT BS 907, STR 4R AND STR 4L. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA031487Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA031428Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A, ABOVE STR 17L. REPAIRED SKIN PER SRM.SDR SWAA031427Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 495, ABOVE STR 16L. REPAIRED SKIN PER SRM.SDR SWAA030627Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED ( 3 EA ) AT BS 518 @ STR 19R, BS 800 @ STR 21L & BS 942 @ STR 25R. REPAIRED SKIN PER SRM.SDR SWAA030417Casting · crackedFLT ATTENDANT REPORTS LOUD HUM AND VIBRATION LT SIDE OF CABIN FROM ROWS NR 6 THROUGH ROW NR 17. REMOVED AND REPLACED NR 4 GROUND SPOILER PER MM.SDR SWAA030001Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN OPENING DOOR. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA022925Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 222 AND LBL 2 TO LBL 3. REPAIRED BULKHEAD WEB PER BFG ER.SDR SWAA022856Skin · crackedDURING SCHEDULED C2 CHECK, FOUND A 3.5 FUSELAGE SKIN CRACK, BS 807, STRINGER 19L. REPAIRED SKIN PER SRM.SDR SWAA022855Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE CABLE MISROUTED. REROUTED SLIDE CABLE PER MM.SDR SWAA022854Bushing · wornDURING SCHEDULED C2 CHECK, LT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR CONTROL ROD END BUSHING PER MM.SDR SWAA022061Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 487, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA022060Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 12L, BS 500D + 2 AND BS 500D + 18. REPAIRED SKIN PER SRM.SDR SWAA022059Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND SKIN CRACKED ON BOTH CAPTAIN'S AND FIRST OFFICER'S WINDOW POSTS. REPAIRED SKIN PER SRM.SDR SWAA022058Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED (4 EA) ABOVE STR 10L, BS 500D + 16, BS 500A + 12, BS 500C + 5 AND BS 500A + 2. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA022012Stud · looseAFTER DEPARTURE AN ELECTRICAL FUME WAS NOTICED, CABIN CREW CONFIRMED FUME. NO CB'S TRIPPED, AC AND DC LOADS ALL NORMAL. FUMES DIMMISHED BUT NOT ELIMINATED. FOUND BLUE FLUID FROM FWD LAV LEAKING AT PRESS FILL. FOUND LOWER ENTRY LIGHT SHORTED OUT DUE TO LAV SDR SWAA021284Bushing · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, LT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB BUSHINGS PER MM.SDR SWAA021217Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA021166Skin · crackedDURING SCHEDULED BC4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA021014Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C + 5, ABOVE STR 15R. REPAIRED SKIN PER MM.SDR SWAA013403Slide · out of positionAFT ENTRY DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA012997Lens · obstructedDURING SCHEDULED C2 CHECK, FOUND EMERGENCY EXIT LIGHT LENS OBSTRUCTED AFT OF L1 DOOR. CLEANED LENS PER MM.SDR SWAA012894Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012860Slide · out of positionFOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA011988Stiffener · crackedDURING SCHEDULED 1/4D CHECK, FOUND MLG WHEEL WELL BULKHEAD VERTICAL STIFFENER CRACKED AT BS 663, RBL 6.5. REPAIRED STIFFENER PER SWA RA.SDR SWAA011976Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL CHORD CRACKED AT BS 178, LBL 5.7 & WL 184. REPAIRED CHORD PER SRM.SDR SWAA011957Wire Rope · frayedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE FRAYED AND MISROUTED. REMOVED AND REPLACED EVAC SLIDE CABLE PER MM.SDR SWAA011963Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND WEB CRACKED AT BS 178, LBL 11.0, WL 218. REPAIRED WEB PER SRM.SDR SWAA011953Sign · looseDURING SCHEDULED 1/4D CHECK, FOUND OVERWING EMERGENCY EXIT SIGN LOOSE AT LT CABIN INTERIOR. SECURED EXIT SIGN PER MM.SDR SWAA011997Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND KEEL BEAM CORRODED AT BS 520, STR 28L. REPAIRED KEEL BEAM PER SWA RA.SDR SWAA011941Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17.1, WL 180. REPAIRED WEB PER SWA RA.SDR SWAA011927Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED WEB CRACKED AT BS 665, RBL 38. REPAIRED WEB PER SWA TI.SDR SWAA011276Uplock Sensor · out of adjAIR TURNBACK, RT GEAR UNSAFE LIGHT ILLUMINATED WITH GEAR HANDLE IN THE OFF POSITION. ADJUSTED RT GEAR UPLOCK SENSOR PER MM.SDR SWAA010150Sensor · malfunctionedDIVERSION, AT FL370, LOST PNEU BLEED PRESS DURING DESCENT, BLEED TRIP OFF LIGHT ILLUMINATED. BOTH DUCT PRESS INDICATORS SHOWED APPROX 65 - 75 PSI. COULD NOT DUPLICATE PROBLEM. PERFORMED PRESS DECAY CHECK, PRESS CONTROL CHECK AND BLEED AIR OPS CHECK OK PER SDR SWAA002398Slide · unsecureAFT ENTRY DOOR SLIDE GIRT BAR STRAP NOT SECURE. SECURED PER MM.SDR SWAA001720Light · brokenDURING SCHEDULED RON, FOUND EEPLS BROKEN/LOOSE AT MID CABIN. REMOVED AND REPLACED LIGHT ASSY PER MM.
Back to N673AA, cancelled Apr 21, 2009