N319SW, cancelled Aug 28, 2008
Service difficulty reports · 200
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 = 'N319SW' AND deregistration_id = 'N319SW-2008-08-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 = 'N319SW' AND deregistration_id = 'N319SW-2008-08-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 SWAA040646Keelbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND RT KEEL BEAM WEB CORRODED AT BS 727 + 11, STRINGER 27R, BS 727 + 14, STRINGER 27R. REPAIRED WEB SECTION PER ER.SDR SWAA040573Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR ASSEMBLY FRAME CRACKED AT NR 3 AFT STOP MOUNT. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA040572Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO DOOR FRAME CUTOUT CRACKED AT FORWARD SIDE OF CUTOUT, BY CENTERING PAD. REPAIRED FUSELAGE FRAME PER EA.SDR SWAA040564Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB PER SRM.SDR SWAA040563Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR CUTOUT FRAME CRACKED AT THE NR 6 AND NR 7 STOPS. REPAIRED FRAME PER SRM.SDR SWAA040554Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR FRAME CUTOUT CRACKED AT FORWARD WEB. REMOVED AND REPLACED WEB PER SRM.SDR SWAA040531Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND WING CENTER SECTION BEADED WEB CRACKED AT RBL 38. REPAIRED WEB PER SRM.SDR SWAA040526Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND CRACKS IN FUSELAGE SKIN AT BS 727E + 3, STRINGER 18R, AND BS 924, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA032539Skin · crackedDURING SCHEDULED PM CHECK, FOUND 4 IN LONG FUSELAGE SKIN CRACK AT BS 727E, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA031973Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500B + 4, STR 14L. REPAIRED SKIN PER SRM.SDR SWAA031874Battery Pack · dischargedDURING SCHEDULED RON, FOUND BOTH AFT CABIN DOORS OVERHEAD EMERGENCY EXIT LIGHTS BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA031411Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED (2 EA) BS 727E PLUS 12 AT STR 19R AND BS 520 AT STR 16L. REPAIRED SKIN PER SRM.SDR SWAA031393Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED (2 EA) BS 520 AT STR 16L AND BS 727E AT STR 19R. REPAIRED SKIN PER SRM.SDR SWAA031199Indicator · out of positionDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA031121Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727C, BETWEEN STR 18R AND STR 19R. REPAIRED SKIN PER SRM.SDR SWAA030577Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 520, BETWEEN STR 12R & STR 13R. REPAIRED FRAME PER SRM.SDR SWAA030576Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED ( 3 EA ) AT BS 500D, STR 13R & BS 520, STR'S 12R & 12L. REPAIRED SKIN PER SRM.SDR SWAA030570Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND PAX WINDOW CUTOUT CRACKED AT RH WINDOW # 9. REPAIRED SKIN PER SWA ERO.SDR SWAA030569Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 500D, BELOW STR 10R. R&R SHEAR TIE PER SRM.SDR SWAA030568Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA030561Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 663.75, STR 2L. REPAIRED FRAME PER SRM.SDR SWAA030535Tie Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER TIE CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR SWAA030507Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA 3.5 IN LONG CRACKS AT FUSELAGE SKIN, BS 941 AND BS 972, BELOW STRINGER 21L. REPAIRED SKIN PER SRM.SDR SWAA030499Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, BETWEEN STRINGERS 13L TO 14L. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR SWAA030485Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 360, STRINGER 14L. REPAIRED SKIN PER SRM.SDR SWAA030484Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER 4R CRACKED BETWEEN BS 663 AND BS 727. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA030449Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA030058Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022502Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 4R, BS 597 AND BS 706. REPAIRED SKIN PER SRM.SDR SWAA022501Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA021337Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA021201Cover · missingDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED LIGHT COVER PER MM.SDR SWAA021078Light · erraticAIR TURNBACK, DURING CLIMB ENG ANNUNCIATOR WARNING LIGHT ILLUMINATED, ALL ENGINE PARAMETERS CHECK NORMAL. REMOVED AND REPLACED F/O'S SIX PACK LIGHTS PER MM.SDR SWAA020876Tab · crackedDURING SCHEDULED A1 CHECK, FOUND LT ELEVATOR TAB INBD CONTROL ROD ATTACH POINT CRACKED. REMOVED AND REPLACED LT ELEVATOR TAB PER MM.SDR SWAA020556Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSLAGE SKIN CRACKED AT AFT SVC DOOR ON LOWER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA020378Slide · looseFWD SVC DOOR EMERGENCY EVAC SLIDE NOT SECURED IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA013417Slide · looseFWD ENTRY DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA012771Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACK ( 2 EA ) AT BS 932, STR 24L & BS 930, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA012388Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 180, WL 224, RBL 17.1 & BS 185, WL 227, LBL 17.1. R&R WEBS PER SRM.SDR SWAA012387Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT BS 440, STR 23R. REPAIRED FRAME PER SWA T1-653-044.SDR SWAA012367Slat · crackedDURING SCHEDULED 1/2D CHECK, FOUND # 1 L/E SLAT CRACKED AT MID AUX TRACK CUTOUT. R&R SLAT PER MM.SDR SWAA012346Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT BS 492, STR 23R. REPAIRED FRAME PER SWA T1-653-044.SDR SWAA012315Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAM CRACKED AT BS 947, LBL 56. REPAIRED FLOOR BEAM PER SRM.SDR SWAA012323Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAMS CORRODED AT BS 727E & BS 772, LBL 12. REPAIRED FLOOR BEAM PER SWA RA.SDR SWAA012287Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD BULKHEAD WEB CRACKED AT BS 1016, STR 2R. REPAIRED WEB PER SRM.SDR SWAA012277Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM AT BS 987, LBL 17 TO LBL 44.5. REPAIRED FLOORBEAM PER SRM.SDR SWAA012265Slat · crackedDURING SCHEDULED 1/2D CHECK, FOUND # 6 SLAT LOWER SKIN CRACKED INBD OF ACTUATOR. REPAIRED SLAT PER SRM.SDR SWAA012267Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIES CORRODED AT BS 827 BETWEEN STR 27R & STR 27L. REPAIRED SHEAR TIES PER SRM.SDR SWAA012268Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIPS CRACKED AT BS 500C & BS 500D, STR 25R. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA012266Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL BEAM WEB CRACKED .50 LONG AT BS 185, RBL 17.1 & WL 227. R&R VERTICAL BEAM WEB PER SRM.
Back to N319SW, cancelled Aug 28, 2008